• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1134
  • Last Modified:

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?
0
scbdpm
Asked:
scbdpm
  • 2
1 Solution
 
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
 
Patrick MatthewsCommented:
Worksheets("Name of WS").Cells.ClearContents
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now