Codes recently updated Codes updated recently by our developers. 15 most recent codes.

{{$CodeName$}
IsThere1_Folder v3

Checks if a folder is found or not, can pass either mapped path or unmapped ...

Thu 5PM

{{$CodeName$}
Excel-VBA Limits v4

These are some limits I found during my work in Excel-VBA For more of Excel ...

Jul18

{{$CodeName$}
SettingRead+SettingSave v3

This is the final version of my set of Setting functions SettingRead, ...

Jul18

{{$CodeName$}
HTMLPadding_or_Margin v6

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jul18

{{$CodeName$}
CutLeftNumber v2

Cuts the left part of string as long as it is number Keeps getting characters ...

Jul18

{{$CodeName$}
ANmaSearch_AmpFriends v2

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

Jul13

{{$CodeName$}
Max + Min v2

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

Jun5

{{$CodeName$}
ANStrFind_AndOrAdd v3

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

May31

{{$CodeName$}
ANmaSQL_InsertStatement v3

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

May25

{{$CodeName$}
MatchIF5 v2

Searching for rows having 5 values in 5 columns Like

May16

{{$CodeName$}
MatchIf2Up v2

Search for 2 items in 2 columns starting from last row upword (Starting with ...

May16

{{$CodeName$}
MatchIfUp or MatchIfRev v2

Searching for an item in a column from bottom to top. Will search for item in ...

May16

{{$CodeName$}
CountColumnCells + CountColumnCells_Criteria v2

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

Apr29

{{$CodeName$}
FileDate_Formatted v2

Returns a formatted version of file 'LastModified' date. Pass parameter ...

Apr29

{{$CodeName$}
CutString1 v3

Cuts a string from a string starting from a specific character index and until ...

Apr3