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 ...

ANmaCellFormat

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

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

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

HTMLTagID_Previous

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