View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Deleting Contents of Sheets

I have a routine which deletes all the contents of a
sheet. Clear All only takes out the text, and
formatting. How do I also get rid of any charts, buttons
or other objects? Without deleting the sheet, I need to
make the sheet completely empty.


THanks