Look at this link. Microsoft article explains how this can be done. You may
have to modify the code somewhat since you want the additional data to go
into column B rather than to the next sheet.

Alok Joshi

"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