Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Similar codes
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Concatenate_HTMLColumn
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
CopyRowHeight
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Long filename
How to delete or rename file with long filename, say more than 200 chars. ...
2020Oct11
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
Windows 7 Photo Viewer
Reg file to show Windows Photo Viewer as option to open images with. ...
2020Sep19
FileDateTime
Gets time and date for a file, Date created, accessed or modified. If the file ...
2018Jul5