Search results 503

Sorted from new to old.

Unblock blocked macros.

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

2024Jul27

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

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

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

2024Jul11

ANmaSearch_AmpFriends

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

2024Jul7

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

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

Min_No0s

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

2024Jun5

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31

MatchIf6

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

2024May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27

1 2 ...5 ...31 32