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
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
