VBA 123

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel
Sorted from new to old.
Card image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Card image
ANmaSpecialFolders

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

Card image
QuarterNumber_FromDate

Returns the number of quarter from a date

Card image
ANStr_Add10IfNotBlank_NorNA

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

Card image
DecimalPlaces

Returns how many decimal places the number have

Card image
IfString_StartsWith_AndOr_EndsWith

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

Card image
ANmaSearch_QuoteFriends

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

Card image
ANmaReplace_Occurrence

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

Card image
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Card image
ANmaSearch_AposFriends

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

Card image
ANmaSearch_AmpFriends

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

Card image
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Card image
Q_NoOfdays

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

Card image
ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Card image
HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

Card image
NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...