NO, that is the limit.

If you must read more, you will need to manage it manually, maybe split the
csv file and read them into multiple sheets, or read the CSV file in VBA and
place in on separate sheets. The first is definitely simpler.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ibu" wrote in message
...
is it possible to increase the number of rows of a worksheet beyond 65536?
if
yes, how? if no, any workarounds? I need to read in a text file in CSV
format
with more than 1,000,000 lines.

thanks!