Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |