COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

Str2DB + Str2App + Str2HTML

Set of functions to clean and revise cleaning of string before saving into ...