Search results 20

Card image cap
UI_2ValidationsUpdate

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

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

Card image cap
Add2Column

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

Card image cap
Copy formulas

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

Card image cap
CopyRowHeight

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

Card image cap
DirTree.xlsb

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

Card image cap
UnMergeFill

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

Card image cap
User-Defined Formatting

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

Card image cap
CellSave_Hyperlink

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

Card image cap
SplitTo2DArray

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

Card image cap
CellSave (SimpleSave)

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

Card image cap
CellHyperlink_ToSheet

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