ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ChartObject Name Restricion or Excel Bug (https://www.excelbanter.com/excel-programming/323092-chartobject-name-restricion-excel-bug.html)

Gaston

ChartObject Name Restricion or Excel Bug
 
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



All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com