charts; myChart.SeriesCollection(10).Name; lots of quotes

[cate]

Playing with charts and saw this in a recording:

ActiveChart.SeriesCollection(10).Name = "=""""""NBT"""""""

I was changing the name of a series to a text string of NBT. What is
the reason for all the quotes.?

FYI. Using a range (I selected the cell with the name as a text
string" gives this:

ActiveChart.SeriesCollection(10).Name = "=Sheet1!R26C2"

Thank you.

 

[Jon Peltier]

What version of Excel? (I think I know...)

Just use this:

ActiveChart.SeriesCollection(10).Name = "NBT"

- Jon

 

[cate]

What version of Excel? (I think I know...)

Just use this:

     ActiveChart.SeriesCollection(10).Name = "NBT"

- Jon

2003
Yes, that's what I did. But I run into so many "things" I just wanted
to be sure. Thank you.