Search results 217

Sorted from new to old.
Card image
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Card image
IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Card image
HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

Card image
MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Card image
Daily folder

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

Card image
Unblock blocked macros.

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

Card image
DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

Card image
ANStr_Add10IfNotBlank_NorNA

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

Card image
Center Userform

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

Card image
CutString97

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

Card image
Min_No0s

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

Card image
ANmAdd_ThenSort_2Columns

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

Card image
ANmaHTMLTables_Combine2

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

Card image
ANmaCellFormat

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

Card image
SortArea4

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