Search results 559

Card image cap
Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

Card image cap
CanAccessVBA

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

Card image cap
AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

Card image cap
BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

Card image cap
HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

Card image cap
ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image cap
MatchIf (aka VMatchIf)

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

Card image cap
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

Card image cap
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

Card image cap
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

Card image cap
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...