I think this is an issue with the Integer limit.

Integer variables are stored as 16-bit (2-byte) numbers ranging in value
from -32,768 to 32,767.

Chnage the code for:
Dim RowNdx As Integer to Dim RowNdx As Long



wrote in message
ups.com...
I have a space delimmited text file. I have read up on how to import
this using VBA and come across the script at this site

http://www.cpearson.com/excel/imptext.htm

This worked great until I imported a text file with 32767 rows in. (I
doubt it is coincedence that this is exactly 50% of the top limit)

I don't think the results will ever be over the limit of 65536 so I do
not need to use any error checking for that.

Basically I get an error stating "Runtime Error 6 Overflow" and when I
stop the macro I notice all text has been imported up to row 32767

Can anyone help?

Thanks if you can

Dan