Thanks to bith of you guys, the link helped perfectly.
Allan

"Dave Peterson" wrote:

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default...;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

It actually puts the extra lines into a new worksheet, but I bet it could be
modified to go to the next column.

Allan wrote:

I am tring to import text files, into column A, but some files contain more
than 65536 rows. I would love to get the rest of the file in Column B if when
the file contains more than 65536 rows

--

Dave Peterson