Test if a user defined chart name is valid
 

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

Test if a user defined chart name is valid
 

On Oct 25, 4:24*pm, Fan924 wrote:
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 ?

Test if a user defined chart name is valid
 

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.

Test if a user defined chart name is valid
 

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

sorry