Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 493
Default dynamic range reference and use of common code

Take a look at Jon Peltier's site:

http://www.geocities.com/jonpeltier/...x.html#hdrDyno

In article ,
clui wrote:

1. I need to graph a range that may change each time the code is run.
How do I reference it? The starting cell is always fixed to F2. But
the ending cell (bottom right cell of the range) is dynamic. It is
determined by how many members in a 2-dimensional array myarray(13,18).
The number of elements in the first dimension changes, but the the
number of elements in the 2nd dimension is always 18. shall I code
it?

Reply
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
Dynamic range where the reference cell can change hello Excel Discussion (Misc queries) 2 May 19th 08 10:11 PM
macro code to get dynamic range ashish128 Excel Discussion (Misc queries) 3 June 15th 07 02:41 PM
Vlookup - dynamic range reference? aseanor Excel Discussion (Misc queries) 7 August 17th 06 11:32 PM
How to dynamically reference a dynamic named range paris3 Excel Worksheet Functions 4 June 24th 05 01:22 AM
Reference to a dynamic range Yossi Excel Discussion (Misc queries) 2 April 12th 05 12:57 PM


All times are GMT +1. The time now is 09:24 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"