Problems with SetSourceData.

[e97fw]

Hi!

Trying to plot data from selective curves from the power-grid. Since the number of data constantly changes I'm having problems with:

ActiveChart.SetSourceData Source:=
Sheets("Blad2&quot.Range("A1:B???&quot, PlotBy:= _ xlColumns

I would've loved do write it like this:

ActiveChart.SetSourceData Source:=
Sheets("Blad2&quot.Range(Cells(1,1),Cells(2,x)), PlotBy:= _ xlColumns

But that doesn't work, someone knows how to get around it?

Thanks in advanced from Sweden.