Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I've been trying to define a range programmatically so that I can set up a graph based on the range. The number of rows in the range will vary depending on when the macro is run. I haven't found a way to define the range within the macro programming language. There doesn't seem to be a property on the range spec. Any ideas of how to do this. Alternatively, I've attempted to use the offset values to determine the range to be included in the graph but haven't gotten this to work. Anyone have any ideas about how to do either of these things (or another approach) so I can have a dynamically set range area for a graph. Thanks, JB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
define max in range (macro) | Excel Discussion (Misc queries) | |||
How do I use a Macro to define a Named Range | Excel Programming | |||
Dynamically Generated Range using Macro | Excel Worksheet Functions | |||
Macro - define cell range for a sum function | Excel Discussion (Misc queries) | |||
Macro to Define Range Name | Excel Programming |