Hello Everyone,

I have three questions concerning a macro I'm trying to write.

I'm importing a text file daily into XL 2003 and saving using the same
filename each day. I'm using the macro recorder to write the macros, since
I'm unfamiliar with VB, then trying to edit.

1. What is the command I need to use to always select the whole sheet, since
the number of lines changes each day?

2.I'm using a vlookup formula. When I run the macro It opens a "Update
Values" window a few times asking for the file reference in vlookup. Once I
respond, it takes forever to continue. Any way to fix this? It doesn't
matter if the referenced file is already opened.

3. Is there a way to automatically insert page breaks each time the data in
a column changes, and ask the user which column to reference?

Thanks for your help,

Dennis