Using Range names in selecting chart series.
 

Hi,

I have a range named DataCount. This will count the number of data points i
have in a column. I would like to use this information when specifying the
series range in chart.



ActiveChart.SeriesCollection(1).Values = "='System 4'!R2C13:R35C13"

In this example I need to substitute R35 with DataCount.



What is the correct syntax?



Thanks in advance,

Cherrs!

Using Range names in selecting chart series.
 

What kind of variable is DataCount? Is it a named range? A VBA
Excel.Range object? A string that contains an address? Does it reference
R35 or R35C13?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



GC wrote:
Hi,

I have a range named DataCount. This will count the number of data points i
have in a column. I would like to use this information when specifying the
series range in chart.



ActiveChart.SeriesCollection(1).Values = "='System 4'!R2C13:R35C13"

In this example I need to substitute R35 with DataCount.



What is the correct syntax?



Thanks in advance,

Cherrs!