Showing Active range for Chart

[Jerseynjphillypa]

I am trying to write a Macro to select the active cell from Z$2 and down. I don't want to write a random number at the end since each week I have more or less rows in my table.

For example

"='Table'!$Z$2:$Z$5969" should be like "='Table'!$Z$2:$Z but I get an error

Please Login or Register  to view this content.

[protonLeah]

Dim LastRow as Long
LastRow=Sheets("whatever?").Cells(Rows.Count,"Z").End(xlUp).Row

ActiveChart.SeriesCollection(1).Values = "='Table'!$Z$2:$Z$" & LastRow