Select the entire col(s) before you apply autofilter. Any blank cells/rows
in-between data lines will "break" autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NanoMark" wrote:
I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?