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" wrote in message
...
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" wrote in message
...
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.