Hi KeepITCool,

Lets vacate this thread and return to the correct venue.

I'll respond with code!


Regards,
Norman,


"keepITcool" wrote in message
...
still offtopic..

ouch.. that wont do.. think about following:
what if my rngA was specialcells(numbers)
or just a manual selection.. nah.. wont do.. :(

--
keepITcool



Norman Jones wrote :

Hi KeepItCool,

I agree with the rationale - its the route I've been following. As
for the check what about :

If AreasCount = 1 and If CountBlanks(Area) Then = Bug Area