How do I reset a sheet completely?

  • Thread starter Thread starter Kenji
  • Start date Start date
K

Kenji

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!

Kenji
 
Kenji, why not just insert a new sheet? You could use a macro like this

Sub Reset()
Cells.Select
Selection.ClearContents
Selection.ColumnWidth = 8.43
Selection.RowHeight = 12.75
Range("A1").Select
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Thanks Paul.

Kenjiro Yagi

Paul B said:
Kenji, why not just insert a new sheet? You could use a macro like this

Sub Reset()
Cells.Select
Selection.ClearContents
Selection.ColumnWidth = 8.43
Selection.RowHeight = 12.75
Range("A1").Select
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
Click to expand...
 
Back
Top