Search results 239

  2. Search results
  3. Return
Sorted from new to old.
Card image
ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Sun 9AM
Card image
ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20
Card image
QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27
Card image
Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

2025Jul17
Card image
ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14
Card image
ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14
Card image
DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30
Card image
ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

2025May26
Card image
FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25
Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12
Card image
1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12
Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10
Card image
MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8
Card image
MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7
Card image
MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3
Card image
ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19
12...1415