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 ?