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