Thread: Error message when adding a name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bob Flanagan Bob Flanagan is offline
external usenet poster
  
Posts: 340
Default Error message when adding a name
Try this instead:

ActiveChart.SeriesCollection(1).Name = _
"=" & Range("a1").Address(external:=True, _
ReferenceStyle:=xlR1C1)

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"matelot" wrote in message
...
I get the following errors when trying to add a name to a chart using my
macro.
Code copied directly from recorded macro
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Name = "=A1"

run-time error 1004
Application defined or object-defined error.
Why is it not working?

Thanks


Reply With QuoteReply With Quote