Checking for empty cells in a range

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.

Replies elsewhere, please don't multi-post.

--
HTH

Bob Phillips

"Chris Strug" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> Replies elsewhere, please don't multi-post.
>
> --
> HTH
>
> Bob Phillips
>

My apologies - I posted this one to the wrong group. I was under the
impression I cancelled this post before it went - obviously I missed it.

Sorry.