Search results 226

Sorted from new to old.

Unblock blocked macros.

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

2024Jul27

DateDiff_Networkdays

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

2024Jul25

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

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

ANmaHTMLTables_Combine2

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

2024May16

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

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

CutString11

Cuts long string from certain character to certain character with option to ...

2024Feb24

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

ArCaptcha

Captcha in Arabic, great library, will look forward to apply it in my next ...

2024Feb11

1 2 3 ...14 15