Search for Range not single number

Hi,

I have this code below, how do i search for a range i.e. if the number is greater than 0 or '1 - 100', rather than a single number,

I've tried specifiying 'stringTolookFor = Range("1:100")' but is comes up with an error.

Please Login or Register  to view this content.

Thanks

Originally Posted by jonn

Hi,

I have this code below, how do i search for a range i.e. if the number is greater than 0 or '1 - 100', rather than a single number,

I've tried specifiying 'stringTolookFor = Range("1:100")' but is comes up with an error.

Please Login or Register  to view this content.

Thanks

I don't think you can use Find method to find a range Best way out is to use For.. Next Loop.

eg.

Please Login or Register  to view this content.

A V Veerkar