Hi Toppers,

A potential problem with the use of the COUNTBLANK worksheet function is
that cells containining formulas which resolve to "" are treated as blank.

---
Regards,
Norman



"Toppers" wrote in message
...
Chris,
Use COUNTBLANK function:

=COUNTBLANK(a7:A30)

HTH

"Chris Strug" wrote:

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.