There are lots of ways to check to see if a value is in a list. You did right
with the =0 stuff.



Kobayashi wrote:

Dave,

Many thanks. I tried to use the nested For Each statements but although
this works if you are looking to match a value I'm looking to see if
the value is NOT in the list and so I couldn't get this to work for
that?
However, the If function you also kindly supplied works perfectly as I
can, and I hope this is right?, simply change the '1' to '=0' to
search for an item not in the list.
So, many thanks indeed, this has helped solve one big, long
headache!!!

Regards,

Adrian

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson