Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Simple bootstrap checkbox
From
2019Jul1