If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|