Search results 8

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
IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

Card image
Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

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