Resize range after import

Hi,

I am importing several new rows from text files to a excel sheet. This runs ok and places the rows under the last row in the sheet with values.

The problem:
I am using a list for the existing rows, but the imported rows stays outside the list.
Is there a macro that will resize the list automaticly so the new rows are included?

Hope someone will share their knowledge with me

Gnoke