Help using indirect addressing in chart series
 

Hi,
I have named a single cell "DataCount" and a complete column "DataRange". In
DataCount i have the
count(DataRange) function. I would like to use DataCount when specifying the
series range in a 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,

Help using indirect addressing in chart series
 

val = range("DataCount").Value
ActiveChart.SeriesCollection(1).Values = "='System 4'!R2C13:R" & val & "C13"

"GC" wrote in message
...
Hi,
I have named a single cell "DataCount" and a complete column "DataRange".
In DataCount i have the
count(DataRange) function. I would like to use DataCount when specifying
the
series range in a 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,

Help using indirect addressing in chart series
 

Thank you so much Patrick.
GC


"Patrick Molloy" wrote in message
...
val = range("DataCount").Value
ActiveChart.SeriesCollection(1).Values = "='System 4'!R2C13:R" & val &
"C13"

"GC" wrote in message
...
Hi,
I have named a single cell "DataCount" and a complete column "DataRange".
In DataCount i have the
count(DataRange) function. I would like to use DataCount when specifying
the
series range in a 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,