Hi guys,

Bear with me - im a complete noob when it comes to vba...i need to to a lot of graphs and i need to do it with a Do until loop.

The expression is:

ActiveChart.SeriesCollection(3).Values = "='Excel Tab 1'!R181C2:R181C13"

and I need to replace the cell reference with a variable like:

variable = 181
ActiveChart.SeriesCollection(3).Values = "='Excel Tab 1'!R - variable - C2:R181C13"
variable = variable + 1

What is the correct syntax for that?? I have tried " and :...no luck..

Thanx // JS