Help

[GC]

Hello,
I am trying to set the series of 4 different charts with data from 4
seperate sheets. My sheets are called S1, S2, S3 and S4.
In the example below, I want to substitute the 1 with the variable Count.
What would be the correct syntax.

ActiveChart.SeriesCollection(1).Values = "='S1'!R2C16:R37C16"
Next

I have tried the following:
ActiveChart.SeriesCollection(1).Values = "='S"& Count"'!R2C16:R37C16"
and many variations of this. Can't seem to get it right.

Cheers,
Gerry

 

[Fred Smith]

You need another ampersand:
"='S"& Count & "'!R2C16:R37C16"

Regards,
Fred

 

[GC]

Thanks Fred! Have a great and happy New Year.

Gerry

 

[Fred Smith]

Glad to help. Thanks for the feedback.

Fred.

Thanks Fred! Have a great and happy New Year.

Gerry