Search results 17

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

DirTree.zip

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

Card image cap
RowsCount

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

Card image cap
Match4

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

Card image cap
Match3

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