I'm trying to filter out blanks from a particular column but when I select
that with auto-filter, only the first 246 lines are filtered, The remaining
columns are still displaying blanks.

Before applying the filter I make sure that all filters were cleared. I also
checked that the unfiltered cells did not contain any invisible spaces.

I would be grateful if anyone can through any light on the problem! Thanks!
--
Richard in Chester