Search results 354

Sorted from new to old.
Card image
oShellRun1

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

Card image
Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

Card image
SortArea5

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

Card image
ServerVar

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

Card image
SortArea3

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

Card image
SortArea1

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

Card image
Sort1Col

Sorts a column in Excel, easily, with options

Card image
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

Card image
FormulasFlatten

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

Card image
CellSave (SimpleSave)

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

Card image
SettingRead_JR

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

Card image
CellRead (SimpleLookup)

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

Card image
CellHyperlink_ToSheet

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

Card image
LogSheet_Add + LogSheet_Clear

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

Card image
RowsCount

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

Card image
GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...