Deleting all data in a Worksheet

's Computer Specifications

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

's Computer Specifications

activesheet.cells.clearcontents

Will clear all the values and formulas from the activesheet.

kirkm wrote:
>
> 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

--

Dave Peterson

's Computer Specifications

On Fri, 02 Mar 2007 19:52:14 -0600, Dave Peterson
<(E-Mail Removed)> wrote:

>activesheet.cells.clearcontents
>
Thank you.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting a worksheet but retaining values from the worksheet.	helpdesk@t7.net.au	Microsoft Excel Misc	1	13th Sep 2006 03:00 PM
Deleting filtered out data from a worksheet	Sierras	Microsoft Excel Worksheet Functions	2	20th Jan 2006 09:27 PM
deleting values in a worksheet without deleting the formulas	=?Utf-8?B?cGF0dGk=?=	Microsoft Excel Worksheet Functions	1	28th Oct 2005 09:49 PM
Deleting A Worksheet - There may be data ...	=?Utf-8?B?Q2hheg==?=	Microsoft Excel Programming	3	15th Jul 2005 06:56 PM
how do I delete data from a worksheet without deleting the formul.	=?Utf-8?B?SmFjaw==?=	Microsoft Excel Misc	1	17th Feb 2005 01:25 AM