View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JB JB is offline
external usenet poster
 
Posts: 115
Default Trying to define a range for a graph dynamically within a macro

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