VBA-Excel 362

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
MatchIf2Up

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

Card image
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Card image
ANmaCellFormat

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

Card image
CopyFields_FromTo

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

Card image
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Card image
MatchIfUp or MatchIfRev

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

Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Card image
Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Card image
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Card image
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Card image
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Card image
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...