Exceeding 65,000 rows
 

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 and
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 this
new sheet, and continue to fill in the data starting from cell A1
again.

please help


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=467491