Test if a user defined chart name is valid

[Fan924]

I am changing chart type by macro. Is there a way to test if a user
defined chart name is valid? Excel 2000 & 2007

 

[Master Blaster]

I am changing chart type by macro. Is there a way to test if a user
defined chart name is valid?    Excel 2000 & 2007

you can use something like this:

For n = 1 To 20
On Error GoTo 987687
Chartnames(n) = ActiveSheet.ChartObjects(n).Name
987687
Next n

does this help ?

 

[Fan924]

I should have said template name like in excel 2007
In Windows 98 excel 2000, they are stored here.
"c:\Program Files\Microsoft Office\Office\XLUSRGAL.XLS"

I am looking for a validity test before applying user defined charts
to an existing chart by macro.

 

[Master Blaster]

Please indicate step by step what you would like top do, because this
is not making too much sense.

sorry