Search results 40

Sorted from new to old.

ANmAddress_Value

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

Oct31

CleanArray_2Dim

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

Oct24

ANmAddressRefStyle

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

Sep23

Choose2

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

Aug20

ANmaRead_1stFile

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

Aug11

FindZipFile_WShell

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

Aug2

CutString96_NumberX

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

Aug2

ANstr_Column

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

Jul29

Daily folder

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

Jul28

Quarter1stLastDate_FromQuarterText

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

Jul26

Concatenate_HTMLColumn

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

Mar14

VBInstr_Numeric

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

Feb25

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

1 2 3