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
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
InStr and InStrRev
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
