How to search for a value in range datatype variable

**singhabhijitkumar** · 11-17-2010, 03:49 AM

I have a range datatype variable. I have populated it with values. Now I want to find if it already contains a particular value. How can I do it?

Please Login or Register  to view this content.

**Bob Phillips** · 11-17-2010, 04:24 AM

Please Login or Register  to view this content.

**singhabhijitkumar** · 11-17-2010, 04:55 AM

I want to check if the range contains a particular value... not if the range contains value or not

**snb** · 11-17-2010, 06:59 AM

Why don't you use the method 'Find' ?

**singhabhijitkumar** · 11-17-2010, 07:23 AM

i am a newbie. pls help

**StephenR** · 11-17-2010, 07:28 AM

One way?

Please Login or Register  to view this content.

Re: How to search for a value in range datatype variable