Search results 7

Sorted from new to old.
Card image
COUNTIFS as Rank

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

Card image
Old cell value

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

Card image
GetColumnIndex

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

Card image
a href=#

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

Card image
TreeView

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

Card image
FormulasFlatten

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

Card image
Str2DB + Str2App + Str2HTML

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