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 ...

Apr15

FindAncherURL_InHTMLRow

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

Mar4

ANStrSort3

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

Feb20

MultiRead_JSON

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

Jan13

ReNumber_IDColumn_inTable

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

2023Dec17

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

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

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

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

1 2 3 4