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,

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,

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,