Hi IoM,

Why Excel exports 65535 lines(maximum number) instead of only those with
useful data?

It certainly shouldn't do! I guess it depends how you created and defined
your List object.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev