PC Review


Reply
Thread Tools Rate Thread

Delete all charts on single Worksheet

 
 
Graham Whitehead
Guest
Posts: n/a
 
      30th Oct 2006
Hi,

Does anyone an easy way to delete all of the charts on a particular
worksheet with VBA? thanks


 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      30th Oct 2006
Hi,

Use with care

activesheet.chartobjects.delete

Cheers
Andy

Graham Whitehead wrote:
> Hi,
>
> Does anyone an easy way to delete all of the charts on a particular
> worksheet with VBA? thanks
>
>


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
 
Graham Whitehead
Guest
Posts: n/a
 
      30th Oct 2006
Thank you.

"Andy Pope" <(E-Mail Removed)> wrote in message
news:%23R3$GVB$(E-Mail Removed)...
> Hi,
>
> Use with care
>
> activesheet.chartobjects.delete
>
> Cheers
> Andy
>
> Graham Whitehead wrote:
>> Hi,
>>
>> Does anyone an easy way to delete all of the charts on a particular
>> worksheet with VBA? thanks

>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info



 
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
Re: merging single worksheet files into a single workbook Roger Govier Microsoft Excel Misc 0 5th Dec 2006 05:25 PM
Delete ALL Charts in a WorkSheet (VB) Corey Microsoft Excel Charting 2 4th Oct 2006 08:41 AM
How to save a single worksheet as worksheet name in new folder?? Simon Lloyd Microsoft Excel Programming 4 16th May 2006 03:12 PM
Save a single worksheet in Excel as a single file. =?Utf-8?B?RGFrb3Rh?= Microsoft Excel New Users 4 22nd Feb 2006 04:46 PM
Converting multiple worksheet to a single page worksheet =?Utf-8?B?dGthbmFzb290QHlhaG9vLmNvbQ==?= Microsoft Excel Misc 0 4th Jul 2005 06:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:53 PM.