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,