Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variables to set ranges
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variables to set ranges
yes it is possible SeriesRanges = Range("'DataCollection'!A1505:BR1505") try strCol = "BR" intRow = 1505 SeriesRanges = Range("'DataCollection'!A1505:" & strCol & intRow ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting ranges with multiple variables | Excel Worksheet Functions | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
COUNTIF() With multiple ranges and variables | Excel Discussion (Misc queries) | |||
Using variables in Chart Ranges | Charts and Charting in Excel | |||
Cell Variables and Ranges | Excel Discussion (Misc queries) |