Search results 591

Sorted from new to old.

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

2024Jul27

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

1 2 3 ...36 37