Similar codes
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
LastRow_Remove
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
Concatenate_HTMLColumn
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Recently by developer
CalculateQuarterText
Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...
Jun10
JSON_To_Table
An attempt to read json into table. This one is a work in progress, tested and ...
Jun6
Random Codes
doHighlight
Search for occurrences of a keyword in a string and highlight them, by either ...
2018Jul19
HaveNonEnglish + StringASCIIs
Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...
2018Jun17
.jpg)
Modify SQL table
SQL seams to have issues when we try to modify a table and preserving data, I ...
2018Jun9