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