Search results 619

Sorted from new to old.

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

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

1 2 ...5 ...38 39