Is there a way to delete the beginning part of an array so it doesn't overflow?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Is there a way to delete the beginning part of an array so it doesn't overflow?

FAQ

Thread Tools

Display Modes

01-15-2014, 08:08 PM

omahadivision omahadivision is offline

Windows 7 32bit Is there a way to delete the beginning part of an array so it doesn't overflow?

Office 2007

Novice

Join Date: Oct 2012

Posts: 28

omahadivision is on a distinguished road

Thanks! While reprogramming, I found another problem: I had dimmed "count" as an integer, and apparently Excel doesn't think there's integers above 30,000! I now have the program read the file twice by closing and reopening it and only put the end of the file in the array, and I got it to run on a 70k line file on a seven year old laptop in only a few seconds.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete bookmark which doesn't have a name	rarulkumar	Word VBA	2	04-19-2013 03:19 AM
Control direction of resizing textarea on overflow	noodle	PowerPoint	0	03-31-2013 04:52 AM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Files beginning ~$	RobinW	Word	1	06-28-2012 05:35 PM
Before the table but after beginning of doc?	Jaymond Flurrie	Word VBA	2	08-16-2011 06:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 PM.