Components 59

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...


ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...


SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...


SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...


Sort1Col

Sorts a column in Excel, easily, with options


FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...


CellSave (SimpleSave)

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


SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...


CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...


CellHyperlink_ToSheet

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


LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...


RowsCount

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