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

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Match3

Matching three values at the same time in three columns Just like Match the ...