You could use Find to lookup the value in the range. There is a good example
in VBA Help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"loopoo" wrote in
message ...

Hello!

I want to know if it's possible to direct check if the value from a
cell can be found in the cell of a range, or do I have to compare the
value with all the values from the cell in the range???


Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile:
http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=487136