Hopw do you return a chart series
I guess its something along the line of

MsgBox (ActiveChart.SeriesCollection(1).Range.Address

but not quite right

Just in case im going about this the wrong way I am trying to update the range based on a variable I have determined as the end row of a serie

ie
endrow = (Worksheets("Data").Range("A1").End(xlDown).Row
ActiveChart.SeriesCollection(l).XValues = Worksheets("ASX_Data").Range("A2:A" & endrow & ""

However the A2:A part of the range varies from chart to chart so I want to return this as it currently is on the chart andonly update the end row

Bruc