Test if a user defined chart name is valid

  • Thread starter Thread starter Fan924
  • Start date Start date
F

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
 
I am changing chart type by macro. Is there a way to test if a user
defined chart name is valid?    Excel 2000 & 2007
Click to expand...

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
 
Back
Top