Runtime Error "7": Out of Memory
 

I have written a macro to read in a large tab seperated text which contains
more than 256 columns. The macro is based on the knowledge base article
Q272729. This worked for some file but not all. It seems to keep coming up
with the out of memory error message when I tried to paste a portion on a
long text into a cell. Can anyone suggest any solution?