Search results 713

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

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

Center Userform

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

2024Jul23

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

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

MatchIf6

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

2024May31

ANmaCellFormat

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

2024Apr18

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

SortArea4

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

2024Apr15

1 2 ...4 ...44 45