Hi
then probably you have entered something else in this cell. Check for
lower/upper case and blanks at the beginning/end

--
Regards
Frank Kabel
Frankfurt, Germany

"susan hayes" schrieb im Newsbeitrag
...
On Tue, 2 Nov 2004 22:03:30 +0100, "Frank Kabel"
wrote:

Hi
could you post the complete part of your macro which does this check

I'm sorry I don't understand what you mean by the complete part of
the
macro.
This is exactly as I wrote the code in VBA. When I enter the country
names such as "France" in cell B6, I would get the needed results in
those three cells B60, B61, B63.

Am I doing this wrong?