Clear cell range in excel

How can I clear a range of cells in an excel sheet?

Actually, I am looking to clear the entire sheet. Is this possible?
scbdpmAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Patrick MatthewsConnect With a Mentor Commented:
Worksheets("Name of WS").Cells.ClearContents
0
 
PaulRKruegerCommented:
Highlight the cells (for a group) or,
Click the box above the #1 and the the left of A (to select all cells in the sheet).

Right-click within the sheet and select Clear Contents.
0
 
scbdpmAuthor Commented:
Thanks for the quick response but I posted in VB cause I want to do this in VB not manually!!!!!
0
 
PaulRKruegerCommented:
Ohhhh... didn't notice. Sorry!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.