Search results 618

  2. Search results
  3. Not
Sorted from new to old.
Card image
HaveNonEnglish + StringASCIIs

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

2018Jun17
Card image
ScreenResolution_wxhxtxl

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

2018Jun17
Card image
MatchIf_ThenDelete

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

2018Jun17
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image
WaitFor + ShellWait

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

2018Jun16
Card image
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14
Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11
Card image
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9
Card image
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7
Card image
FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6
Card image
Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2
Card image
StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2
Card image
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2
Card image
RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26
12...3839