1000 items is the limit of Autofilter.

--
Jim Rech
Excel MVP
"Abdullah Kajee" <Abdullah wrote in message
...
| In large spreadsheets more than 1000 rows, I find that Excel ignores
values
| below the 1000th row? Am I doing someting wrong or is it a program error.