Similar codes

code image
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

code image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

code image
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

code image
Row_PixelLocation

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

2021Feb2

code image
Column1Range

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

2023Oct7

code image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

code image
LastRow_Remove

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

2022Aug16

code image
ANstr_Column

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

Jul29

code image
Concatenate_HTMLColumn

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

Mar14

Recently by developer

code image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Sun 3PM

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Sun 6AM

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Sat 6AM

code image
TrimLines

Remove all line breaks from text from a text. Not like

Fri 6AM

Random Codes

code image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

code image
CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

2020Feb1

code image
Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29