C
C Brandt
Try as I might, I can not figure this one out.
I am building an embedded chart that uses data from another sheet. When I
tried to add the data to the chart, the system has a run-time error 1004 (
Method 'Cells' of object '_Global' failed)
The line that generated the error was:
co.Chart.SeriesCollection.Add Source:=Sheets("DB").Range(Cells(ChrtStrt, 9),
Cells(ChrtEnd, 12))
ChrtStrt & ChrtEnd are both valid numbers. I do not understand what is
causing this error.
Any suggestions?
Thanks,
Craig
I am building an embedded chart that uses data from another sheet. When I
tried to add the data to the chart, the system has a run-time error 1004 (
Method 'Cells' of object '_Global' failed)
The line that generated the error was:
co.Chart.SeriesCollection.Add Source:=Sheets("DB").Range(Cells(ChrtStrt, 9),
Cells(ChrtEnd, 12))
ChrtStrt & ChrtEnd are both valid numbers. I do not understand what is
causing this error.
Any suggestions?
Thanks,
Craig