UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

DirTree.zip

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...