Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
moglione1
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM
Can the max. number of 65,000 rows in Excel be increased? JWallCovista Excel Discussion (Misc queries) 2 May 24th 05 03:03 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"