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!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements