Search results 698

Sorted from new to old.

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

Unblock blocked macros.

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

Jul27

DateDiff_Networkdays

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

Jul25

ANStr_Add10IfNotBlank_NorNA

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

Jul24

DecimalPlaces

Returns how many decimal places the number have

Jul24

Center Userform

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

Jul23

IfString_StartsWith_AndOr_EndsWith

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

Jul18

ANmaReplace_Occurrence

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

Jul13

ANmaSearch_AmpFriends

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

Jul7

Q_NoOfdays

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

Jun9

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

CutString97

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

Jun5

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

MatchIf6

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

May31

ANmaCellFormat

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

Apr18

CopyFields_FromTo

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

Apr17

1 2 3 ...43 44