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

Card image cap
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Card image cap
SortArea5

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

Card image cap
ServerVar

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

Card image cap
SortArea3

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

Card image cap
SortArea1

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

Card image cap
Sort1Col

Sorts a column in Excel, easily, with options

Card image cap
FormulasFlatten

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

Card image cap
CellSave (SimpleSave)

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

Card image cap
SettingRead_JR

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

Card image cap
CellRead (SimpleLookup)

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

Card image cap
CellHyperlink_ToSheet

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

Card image cap
LogSheet_Add + LogSheet_Clear

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