value in range
 

What is the fastest way to check if a range contains a specific value?

value in range
 

=COUNTIF(A1:B10,123)

Regards,
Peter T

"polilop" wrote in message
...
What is the fastest way to check if a range contains a specific value?

value in range
 

VBA has a Find function, check it in VBA help, there is a good example.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"polilop" wrote in message
...
What is the fastest way to check if a range contains a specific value?