Search results 44

Sorted from new to old.

1st cell of sheet range

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

Mon 1PM

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

2024Aug2

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

1 2 3