Shane & Debra,

Thank you for your help. It worked. Just what was needed.



"ronlaforce" wrote:

I need to filter for blank cells. It will usually be a single criteria in
more than one column. It will be 'and'.

I know that I have to place all criteria in the same row for 'and'.
However, I can't seem to filter out the blank cells. I keep getting nothing
or everything. What is the correct method for filtering for blank cells?

Thx,

Ron