use vba to write vba for a chart sheet created on the fly

[chris_parker_2003@yahoo.co.uk]

How do I write vba using vba for a chart sheet I have just created on
the fly?
I 've noticed excel gives the vbcomponent a different name to the chart
name which makes it difficult to select the correct vbproject
Thanks

[K Dales]

Depends on how you create the chart sheet, but if with the Charts.Add method
then
Dim NewChart as Chart
Set NewChart = Workbooks("WorkbookName").Charts.Add()

Now use the variable NewChart to refer to the chart object, or use its .Name
property if you need that.
--
- K Dales


"chris_parker_2003@yahoo.co.uk" wrote:

> How do I write vba using vba for a chart sheet I have just created on
> the fly?
> I 've noticed excel gives the vbcomponent a different name to the chart
> name which makes it difficult to select the correct vbproject
> Thanks
>
>