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 Whe=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