Search results 111

Sorted from new to old.
Card image
ServerVar

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

Card image
HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

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
InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

Card image
Hex2Dec

Converts hexadecimal strings into decimals

Card image
Dec2Hex

Converts integer decimals into Hexadecimals

Card image
IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

Card image
CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Card image
Match4

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

Card image
Match3

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

Card image
Match2

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

Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...