Thread: Clear a sheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Burton Kevin Burton is offline
external usenet poster
 
Posts: 19
Default Clear a sheet.

I want to use one sheet as a kind of work area. I plan on filling up cells
with data from various places. To make things easier for this kind of
application I would like to be able to clear a sheet. I want it just as it
started, no tables, no charts, no named ranges, clear all of the data/cells,
etc. I could not find something like sheet.Clear(). If I get a reference to
the work sheet like:

Excel.Worksheet baseSheet = this.Worksheets[1] as Excel.Worksheet;

How would I clear this worksheet?

Thank you.

Kevin