Hi dcknie

See
http://www.contextures.com/xlautofilter02.html#Limits



--
Regards Ron de Bruin
http://www.rondebruin.nl


"dcknie" wrote in message ...
When using auto filter on a spreadsheet that has over 1005 lines of data the
auto filter will not list any data after line 1005. What can I do to have it
list all the data?
I have a spreadsheet of names with their phone numbers that goes to line 1044.