Clear the content of a worksheet using VBA

  • Thread starter Thread starter Shawshank
  • Start date Start date
S

Shawshank

I want to clear the content of a whole worksheet using VBA.
Does anyone know how to do it?

Thanks!
 
Try something like

Worksheets("Sheet1").Cells.Clear ' or ClearContents


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
ActiveSheet.Cells.ClearContents

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Excel VBA 0
Disable Clear DContents command in excel - vba code?? 3
How to clear the clipboard contents in VBA 1
Clear all rows except first two 7
How to assign a worksheet in VBA 3
Disable worksheet macros when copying a worksheet in VBA 2
Clear contents of cells hidden by autofilter 3
Clear Contents of Specific Cells in Last Row 2

Back
Top