Search results 244

Sorted from new to old.

ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Sun 6AM

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

DuplicatedList

Returns list of duplicated items in a range as ... ' ...

Jun21

CutString_Area

Returns full area found in ThePage between Between_Char1 and and_Char2 that ...

Jun1

File1st_Attributes_In

Gets details of first file found in folder, based on requested order, byt name, ...

May31

ANmaTableAddress

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

Apr26

ANStrColor2RGBA_Para

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

2025Dec20

QTexts_Min

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

2025Jul27

Icon as text - CmdCaption_ChrW

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

2025Jul17

ANStrVLookupAll

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

2025Jun14

ANStrVLookup

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

2025Jun14

DBTableCol_Array

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

2025May30

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

2025May26

FilesIn_4Array

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

2025May25

UsedRange

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

2025May12

1st cell of sheet range

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

2025May12

1 2 ...15 16