Similar codes
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
Listbox height changing issue
Listbox in Excel sometimes have issue adjusting height to items added inside, ...
2018Aug25
LastRow_Remove
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
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
FrmAbout
Display a string in a Userform as 'About' window, can display string or file by ...
2018Jun11
DownloadFile
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22