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" <Toppers@discussions.microsoft.com> wrote in message
news:9F0D3FEE-9014-4DC4-847E-25AB484FF14C@microsoft.com...
> 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.
>>
>>
>>
>>