Search results 103

  2. Search results
  3. values
Sorted from new to old.
Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9
Card image
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7
Card image
Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7
Card image
Capitalize

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

2018Jul3
Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30
Card image
FormulasFlatten

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

2018Jun30
Card image
CellHyperlink_ToSheet

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

2018Jun24
Card image
FS_CopyFile

Copies a file

2018Jun24
Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21
Card image
FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

2018Jun20
Card image
DirsCombo_Read

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

2018Jun18
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
Match4

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

2018Jun16
Card image
Match3

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

2018Jun16
Card image
Match2

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

2018Jun16
12...67