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

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 ?

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.

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

sorry