View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] no.reply7@comcast.net[_2_] is offline
external usenet poster
 
Posts: 6
Default 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