I do my best never to let excel guess the range to sort/filter/chart/pivottable.

And I've never seen any of those fail if I select the range first--no matter how
many gaps there were.

I have no idea why it didn't work for tombogman. I'd suggest that he remove the
filter and try it again.

Sandy Mann wrote:

"Dave Peterson" wrote in message
...
If you select your range first, the autofilter should work against that
selection--even if there are empty rows/columns.

I actually tried that before posting but it failed. I did not realise that
you had to select the range BEFORE applying the autofilter. The OP had the
autofilter already on so it failed when I just selected the range and tried
selecting a filter it failed.

--
Regards

Sandy

with @tiscali.co.uk

--

Dave Peterson