MatchIF5

Searching for rows having 5 values in 5 columns Like

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

MatchIf2Up

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

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

SettingSave + SettingRead for NumberFormat

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

ANmaCellFormat

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

ListBox bug with TabIndex

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

MatchIfUp or MatchIfRev

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

CopyFiles Excel-Macro

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

CopyFiles.zip

Triangular coded msg in file

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

FindAncherURL_InHTMLRow

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

DateDateDate

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