View Single Post
  #1 (permalink)  
Old June 11th, 2003, 04:15 AM
Cclhodges Cclhodges is offline
Registered User
Join Date: Jun 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Variable data ranges for charts


I want to create a chart with the data range dependant on certain variables. have tried the following to no effect any ideas?

i.e. .Range(.cells(x,y),.cells(i,j))

I have tried several variations but none are accepted

The actual code line is:

ActiveChart.SetSourceData Source:=Sheets(Country(i, 1)).Range(Cells(2, 2), Cells(2, maxdate - 1987))

Any suggestions appreciated.
Reply With Quote