Excel 2007 : Use a variable instead of a hard coded value

Hi folks,

This should be an easy one.

Below is a line of code that works fine:

ActiveChart.SeriesCollection(2).Values = "='AIO-Cond'!$L$4:$L$6725"

But instead of the hard coded value 6725, I want to use my variable LastRow (Dim as Integer).

How should I format the new code? I have tried simple things like:

ActiveChart.SeriesCollection(2).Values = "='AIO-Cond'!$L$4:$L$ & LastRow"

And I get '1004' errors.

Can you folks tell me how to do this right, or if not "right" just so it will work?!

- Thomas

You were close:

ActiveChart.SeriesCollection(2).Values = "='AIO-Cond'!$L$4:$L$" & LastRow