SeriesCollection(10).Name = "=""""""NBT""""""" What are all thesequotes?

C

cate

With the goal of some VBA later, I am 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charts; myChart.SeriesCollection(10).Name; lots of quotes 2
Help on adding the second trendline in a "lines on 2 axes" Chart via VBA 1
Chart: range info from seriescollection? 1
VBA error: Unable to set the Values property of the Series class 1
Update Chart data Range with VBA 1
Help: runtime error - Method seriescollection object_chart failed 3
Need help with SeriesCollection Object Please ! 10
Changing a series' Name, X- and Y-values by using its series number 4

Top