Search results 60

Sorted from new to old.

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

Oct10

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

ANstr_Column

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

2024Jul29

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

Concatenate_HTMLColumn

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

2024Mar14

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

2024Jan28

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

2024Jan18

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

Column1Range

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

2023Oct7

1 2 3 4