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 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.