How do I reset a sheet completely?

  • Thread starter Thread starter kenji4861
  • Start date Start date
K

kenji4861

I have one sheet on my excel workbook that I would like to completely
reset.

I want all cells to be cleared and all the rows/height to be default.

How can I do this? Thanks!
 
Nevermind, I just did a
cells.clear
cells.clearformat
cells.useStandardHeight = true
cells.useStandardWidth = tru
 
You can also...

Edit | Delete Sheet
Insert | Worksheet

Regards,
Jim Cone
San Francisco, CA
 
Kenji,

Actually, the Clear method clears contents and formats, so you can skip the
ClearFormat. Also, if you have comments, Data Validation, they'll get
cleared too. Names won't.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reset a sheet completely? 2
How do I reset the columnwidth to sheet-default? 1
EXCEL SHEETS 3
Summary Worksheet. 1
Recording new Macro won't reset drop downs 3
Excel Cannot delete empty cells/rows 4
Merge Multiple workbook sheets into one workbook 0
Formula Audit mode active in one column only; cannot kill. 2

Back
Top