Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Clear cell range in excel

Posted on 2008-10-03
4
Medium Priority
?
1,133 Views
Last Modified: 2010-08-05
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
Comment
Question by:scbdpm
  • 2
4 Comments
 
LVL 4

Expert Comment

by:PaulRKrueger
ID: 22637223
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
 

Author Comment

by:scbdpm
ID: 22637289
Thanks for the quick response but I posted in VB cause I want to do this in VB not manually!!!!!
0
 
LVL 4

Expert Comment

by:PaulRKrueger
ID: 22637509
Ohhhh... didn't notice. Sorry!
0
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 1000 total points
ID: 22638980
Worksheets("Name of WS").Cells.ClearContents
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question