Just press CTRL and click on the chart, you will be able to see the chart name in the name box on the top left corner......
Regards On Aug 29, 4:24 pm, 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 -~----------~----~----~----~------~----~------~--~---
