Various ways and inconsistencies of deleting cells in sheets
I have found inconsistencies in how one deletes all cells in a sheet.
..UsedRange.delete
cells.delete
but once you reset lastrow and lastcolumn, you still find "blank" active cells (not all the time but occasionaly enough that i can screw up you code).
The one which seems to be the most reliable is the following:
cells.EntireRow.Delete
cells.EntireColumn.Delete
I've googled around but have not found any good explanation.
What would a programmer use (I am not a programmer but I am trying to emulate my coding to one)?
Thanks
|