1. Select the range (say A7:A30)
2. Apply autofilter
3. Click down-arrow at Cell A7
4. Check in the list if there is the word "empty"
5. Clicking "empty" you will see the empty cells

Regards,
Stefi


€žChris Strug€� ezt Ã*rta:

Hi,

Probably a silly question but I'm not sure of the best way to achieve it.

Basically, given a range (say A7:A30) what's the best way to see if any of
these cells are empty / null / blank. I don't necessarily need to know which
ones simply that there is one or more blank cell present.

Any advice, links or any other help is gratefully received.

Thanks

Chris.