Mark, that is the limit, next version will be more, have a look at this code
here and see if this will help

http://www.mvps.org/dmcritchie/excel/snakecol.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Mark" wrote in message
...
I wish to import data into Excel that is typically 90K rows long and could
go
to as much as 900K. # of Columns is only say 20 or so.
is there any way to remove the 65536 row limit so the whole data set can
be
imported at once?
Alternatively, is there some snippet of code or idea to import the data
into
multiple sheets?
Many thanks for any advice.