VBA Range Check

[help_for_excel]

Hi,

I want to write a function which checks that names in the range have range.
Countries (USA, UK, Canada, Germany)
USA (12, 01, 5)
UK (50, 56, 5)
Germany (34,09,78)

So there are 4 members in range named "countries". and out of 4 members only 3(USA, UK, Germany) has range, Canada didn't had range.

so function should JUST check all the names in "countries" and tell user that USA, UK, Germany has range in excel and Canada has no range in excel


please help....thanks in advance