Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
discontiguous ranges in charts
I'm trying to create many charts of data meeting specific requirements.
Does anyone know how to get a range mode to include severa discontiguous cells which have been loaded into range variables? have tried Set RangeVar = Range("RangeVar1, RangeVar2, RangeVar3") but that doesn't work unless you use the explicit cell positions o RangeVar1, 2, 3, like A1, A2, and A3. Natha -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
discontiguous ranges in charts
Nathan -
If you put the variable name in quotes, the string evaluated is the variable name, not the contents of the variable. If the variables are string addresses, use this: Set RangeVar = Range(RangeVar1 & ", " & RangeVar2 & ", " & RangeVar3) If they are actual range objects: Set RangeVar = Union(RangeVar1, RangeVar2, RangeVar3) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Pilgrim < wrote: I'm trying to create many charts of data meeting specific requirements. Does anyone know how to get a range mode to include several discontiguous cells which have been loaded into range variables? I have tried Set RangeVar = Range("RangeVar1, RangeVar2, RangeVar3") but that doesn't work unless you use the explicit cell positions of RangeVar1, 2, 3, like A1, A2, and A3. Nathan --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect a cell in a discontiguous range | Excel Discussion (Misc queries) | |||
Is it possible to plot discontiguous cells? | Charts and Charting in Excel | |||
Is it possible to plot discontiguous cells? | Excel Discussion (Misc queries) | |||
2 DATA RANGES IN CHARTS | Charts and Charting in Excel | |||
Defining a discontiguous Range object | Excel Programming |