If I recall there were ways to add rows with a user form but thats been a
while. Excel 07 is supposed to have over a million so that is an option, I
haven't seen first hand though :(
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Deborah" wrote:

Sometime ago I had a macro that would automatically add lines in a worksheet
if the file being imported was larger than the worksheet. I have since lost
that macro.

Does anyone know what it is?