dynamic range reference and use of common code

  • Thread starter Thread starter clui
  • Start date Start date
C

clui

I have 2 questions.

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?

2. I need to use the following piece of code in multiple places in my
program:
..fieldnames=true
..rownumbers=false
..refreshonfileopen=true

Basically I'm setting properties for an imported file. I need to
import multipe files, and I suppose I can use the same property
settings for each one of the imports. How do I code it so that I can
write that code once and use it repeatedly?

Thanks!
 
For the first, if you always have 18 series with a varying amount of
points, you could just make a dynamic chart, which has series based on
dynamic named ranges. Check out examples and links:
http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

If the number of series is varying, you can't do it quite so smoothly,
but you could define a dynamic named range (same instructions as above
setting up the range), then use it in a SetSourceData statement for the
chart.

- Jon
 
Back
Top