Search results 60

Sorted from new to old.

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

CopyDynamicRangeValue

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

2023Aug10

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

1 2 3 4