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

NumberNumberNumber

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

VBInstr_Numeric

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

CutString11

Cuts long string from certain character to certain character with option to ...

SwitchTextinCells

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

Send workbook as email attachment

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

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

GSplitPDF.zip

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...