I have created a ChartObject with a name that contains a dash ('-'). That
works fine. However, when I try accessing by name, I get a 1004 error
message. This tells me that a dash is not allowed in a ChartObject name. If
I create the ChartObject using a space instead of a dash, everything works
fine. An example statement that fails is as follows:

Sheets("sheetName").ChartObjects("ABC-DEF").Delete

My questions a Is this a bug in Excel? If not, what are the
restrictions on ChartObject names? I can't find any documentation on this in
the help. Also, are their other objects with such name restrictions?

Thanks in advance for your help.


Regards,

Gaston