LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
define max in range (macro) Steve Excel Discussion (Misc queries) 3 January 7th 09 01:55 AM
How do I use a Macro to define a Named Range EKUFan Excel Programming 1 September 16th 06 05:15 PM
Dynamically Generated Range using Macro [email protected] Excel Worksheet Functions 2 July 15th 06 08:12 AM
Macro - define cell range for a sum function Fad Excel Discussion (Misc queries) 2 June 6th 05 12:40 PM
Macro to Define Range Name Phil Excel Programming 6 October 23rd 03 04:00 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"