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?