Cell references when creating charts
I want to refer to my cell range using
range(cells(row,column),cells(row,column))
as I am running this within a loop. However the only code I can get to work
is the two forms below. Is there another way or can I use the above syntax a
different way to get around this?
Charts.Add
ActiveChart.ChartType = xlXYScatter
ActiveChart.SeriesCollection(1).Values = Sheets("EV3
flow").Range("B10:B446")
ActiveChart.SeriesCollection(1).XValues ="='EV3 depth'!R10C2:R446C2"
|