ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   SeriesCollection(10).Name = "=""""""NBT""""""" What are all thesequotes? (https://www.excelbanter.com/charts-charting-excel/250730-seriescollection-10-name-%3D-%3D-nbt-what-all-thesequotes.html)

cate

SeriesCollection(10).Name = "=""""""NBT""""""" What are all thesequotes?
 
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.

Herbert Seidenberg

SeriesCollection(10).Name = "=""""""NBT""""""" What are all thesequotes?
 
Excel 2007
Chart VBA with lots of quotes,
and alternate variable presentation.
http://www.mediafire.com/file/owfzdzmzw23/12_12_09.xlsm


All times are GMT +1. The time now is 08:37 PM.

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