Select all data first Dave before you turn on AutoFilter

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave" wrote in message ...
I want to use auto filter on columns, but I have cells that are blank and
when I use the drop down on the auto filter, its doesnt pick up anything
after the blank cells. Is there a way around this, as I do need to have blank
cells in my columns.

Thanks