A list is an object available in Excel 2003. It is basically a dynamic
range that has autofilter turned on by default. It does not work in Excel
97 or 2000, not sure about 2002. This is not the solution I am going to use
because it is not compatible in the older versions.

I created dynamic ranges in the two sheets I will be using as input. The
problem I am running into now is how to dynamically create a dynamic range!

Spreadsheet looks something like this ...

Report Header
Quarter Header
Quarter Data (From DB)
Next Quarter Header
Dynamic Range for quarters activity to be reported and then read by my
program

"Jamie Collins" wrote in message
om...
"Michael Garcia" wrote ...

The question(s) I am getting at is, is a list supported in Excel 97, is
it
necessary for me to use a list to access the information when the
spreadsheet is returned, and is a list really the best solution? I have
never used a list before

Sorry, I don't understand. What do you mean by a 'list'?

Jamie.

--