Trouble with Union

E

Ed

Please see below for original thread.

I've updated the code to read:

ActiveChart.SetSourceData Source:=Sheets("Graph
Data").Union(Range(Cells(1, 1), Cells(PriceBandCounter,
1)), Range(Cells(1, 7), Cells(PriceBandCounter, 7))),
PlotBy:=xlRows

This is returning a Run Time Error 438, Object doesn't
support this property or method...
 
E

Ed

-----Original Message-----
Please see below for original thread.

I've updated the code to read:

ActiveChart.SetSourceData Source:=Sheets("Graph
Data").Union(Range(Cells(1, 1), Cells(PriceBandCounter,
1)), Range(Cells(1, 7), Cells(PriceBandCounter, 7))),
PlotBy:=xlRows

This is returning a Run Time Error 438, Object doesn't
support this property or method...

wrote
in message

.
Click to expand...
 
Top