Thread
:
does range value exist in another range
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
does range value exist in another range
You could use FIND
or just
application.match(range("b5"),range(a1:a10),0)
--
Don Guillett
SalesAid Software
"Spencer" wrote in message
...
is there a simple macro i can run to determine if the value in range("B5")
exists anywhere in range("A1:A10").
similar to the excel function
=MATCH(B5, A1:A10,0)
TIA.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett