PC Review


Reply
Thread Tools Rate Thread

Deleting all data in a Worksheet

 
 
kirkm
Guest
Posts: n/a
 
      3rd Mar 2007

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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      3rd Mar 2007
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
 
Reply With Quote
 
kirkm
Guest
Posts: n/a
 
      3rd Mar 2007
On Fri, 02 Mar 2007 19:52:14 -0600, Dave Peterson
<(E-Mail Removed)> wrote:

>activesheet.cells.clearcontents
>

Thank you.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:55 PM.