Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...
2021Nov26
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
Creates Excel menu on the fly, list of menu items, command actions, and icons ...
2018Jul17