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

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

Card image cap
RowsCount

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

Card image cap
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

Card image cap
DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

Card image cap
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...