I have a a cell containing a string that I want to compare to a range of other cells.
This is what I have to get the string to compare. Cells(r1.Row, 2).Value

How would I compare that string to cells B83:B101 and when the match is found add 1 to that row colC. (say the match was found at B87. I want the to add one to the value in C87 and stop the search).

Thanks