Exceeding 65,000 rows

M

moglione1

Please help. I have a macro that pulls in a text file.

This file has over 65,000 rows. The data pulled fills down sheet 1 an
then once 65,000 rows is reeached a new sheet is inserted.

Once this new sheet is inserted how do i get the macro to activate thi
new sheet, and continue to fill in the data starting from cell A
again.

please hel
 
Top