Thanks guys for all your ideas.

The text files had only 40 rows and were about 200 characters wide, so
there shouldn't have been a problem in fitting all the data on a
worksheet, even at one character per cell.

It appears that my problem was that VBA will only hold so many lines in
any one command. Using the macro recorder got me a text wizard command
that went like..............

Array(1,1), Array(2,1), ....up to Array(97,1)

and then failed.

I got around the problem by deleting some line continuations and
manually filling in the rest. I was able to go up to ...Array(200,1)
without any problems


Once again, thanks for your time

free


--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=399371