Search results 60

Sorted from new to old.

FindAncherURL_InHTMLRow

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

Mar4

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

Feb7

BS5 Cards

2 Cards design in Bootstrap 5 from

2023Nov23

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

AddressReferenceStyle

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

2023Nov1

Column1Range

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

2023Oct7

CopyDynamicRangeValue

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

2023Aug10

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

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

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

RowList_Matching

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

2021Dec27

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

1 2 3 4