Deleting all data in a Worksheet

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

Looking for a method to delete everything in a Worksheet from code.
Not the sheet itself, though.

And, is it possible to keep the structure, i.e the way the columns
have been formatted ?

Many thanks - Kirk
 
activesheet.cells.clearcontents

Will clear all the values and formulas from the activesheet.
 

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

clear all sheets code 4
Passing data to an event handler 3
Protect a single worksheet? 6
Ron de Bruin - Merge cells from all worksheets 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Run macro on all files in a specific folder 3
TextAlign in List Box 1
Sort a Range 2

Back
Top