Hello, I would like to find the value in cell C2 in every case within the range of the value in cell A2 and value of cell B2. In the example here I would like cells B4, B6, and B9 to be highlighted or clearly pointed out somehow. When I run my Macro3 there are a few problems.

1. The results are shown in a message box. I just want the results highlighted.

2. I’m only finding the first found result. I need to see all of them. I was going to try and figure out a loop but the range can sometimes be different.

3. In this example, B4 is not found because it does not start with “gre”.

Thanks for any help.

Attached Files

Book1.xlsm (14.9 KB, 8 views)