thanks a lot, avinash! :)
On Aug 30, 7:03 pm, "avinash verma" <[EMAIL PROTECTED]> wrote:
> Below is a smaple snippet that shows how to use
>
> -- to select the properties
> For Each chrt in ActiveSheet.ChartObjects
> chrtName = chrt..Parent.Name ' chrt name
> if chrtName = "Chart1" then
> chrt.delete
> end if
> Next
>
> --- to set other properties
> With ActiveSheet.ChartObjects("ChartName")
> .Width = 100
> .Height = 100
> .Left = 100
> .Top = 100
> End With
>
> On 8/29/08, XpandeR <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > Hi Folks,
>
> > I'm working on a macro that generates a chart on the basis of just
> > refreshed table. But as the table refreshes each time I need to delete
> > the already existing chart (that is the only one chart on that sheet).
> > Could anyone help me please how can I get the properties/name of that
> > existing chart to make it removed before the new one is created?
>
> > Thanks in advance.
>
> > peter- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
