using variables to set ranges

  • Thread starter Thread starter Dave Marden
  • Start date Start date
D

Dave Marden

is it possible to use a variable to set a range such as I
am trying to do here?

ChartNames = Range("'DataCollection'!A1503:BR1503")
SeriesRanges = Range("'DataCollection'!A1505:BR1505")
Sheets("DataCollection").Select
Charts.Add
With ActiveChart
.ChartType = xlLineMarkers
.SetSourceData Range(SeriesRanges(1, 1)),
PlotBy:=xlColumns
.SeriesCollection(1).XValues = Range
("SeriesCollection")
.SeriesCollection(1).Name = "=DataCollection!R1C5"
.Location Where:=xlLocationAsNewSheet,
Name:=ChartNames(1)

ChartNames is just Names, but SeriesRanges are Ranges. I
want to be able to assign ranges in this manner because
then i can use a for/next loop to assign multiple ranges
which change frequently.

Thanks,
Dave Marden
 
yes it is possible



SeriesRanges = Range("'DataCollection'!A1505:BR1505")

try


strCol = "BR"
intRow = 1505


SeriesRanges = Range("'DataCollection'!A1505:" & strCol & intRow
 
Back
Top