indirect addressing
 

I need to adjust the series range as follows;

I have a cell with a range name "EndData". This will be used to set the end
of the series for my line chart. The example below will select data from F5
to F22. I need to replace the 22 in F22 with my cell called EndData which
could have a value of 50 for example. What would be the correct syntax?

ActiveChart.SetSourceData Source:=Sheets("Data").Range("F5:F22"), PlotBy:=
xlColumns

Thanks a bunch,
Gerry

indirect addressing
 

Sheets("Data").Range("F5:F" & Range("EndData"))

Mike F
"GC" wrote in message
...
I need to adjust the series range as follows;

I have a cell with a range name "EndData". This will be used to set the
end of the series for my line chart. The example below will select data
from F5 to F22. I need to replace the 22 in F22 with my cell called
EndData which could have a value of 50 for example. What would be the
correct syntax?

ActiveChart.SetSourceData Source:=Sheets("Data").Range("F5:F22"), PlotBy:=
xlColumns

Thanks a bunch,
Gerry

indirect addressing
 

Thanks Mike.

"Mike Fogleman" wrote in message
...
Sheets("Data").Range("F5:F" & Range("EndData"))

Mike F
"GC" wrote in message
...
I need to adjust the series range as follows;

I have a cell with a range name "EndData". This will be used to set the
end of the series for my line chart. The example below will select data
from F5 to F22. I need to replace the 22 in F22 with my cell called
EndData which could have a value of 50 for example. What would be the
correct syntax?

ActiveChart.SetSourceData Source:=Sheets("Data").Range("F5:F22"),
PlotBy:= xlColumns

Thanks a bunch,
Gerry