Codes recently updated Codes updated recently by our developers. 15 most recent codes.
ANStrFind_AndOrAdd v3
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
May31
ANmaSQL_InsertStatement v3
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
May25
MatchIf2Up v2
Search for 2 items in 2 columns starting from last row upword (Starting with ...
May16
MatchIfUp or MatchIfRev v2
Searching for an item in a column from bottom to top. Will search for item in ...
May16
CountColumnCells + CountColumnCells_Criteria v2
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
Apr29
FileDate_Formatted v2
Returns a formatted version of file 'LastModified' date. Pass parameter ...
Apr29
CutString1 v3
Cuts a string from a string starting from a specific character index and until ...
Apr3
CellSave_Hyperlink v3
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
Mar22
ProfileBadge_Linkedin v2
Creates Linkedin profile badge for certain user as HTML output as string. ...
Mar12
HTML_InsideTag_ByIndex v2
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Mar12
Send workbook as email attachment v2
Retro way to send a workbook you are in as an email. Found it in one of my old ...
Feb14
NumberBeforeString v2
Cuts a number that would be found before certain word inside a block string. ...
Feb14
ANmaHTMLPadding v4
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Feb14