how to select a cell that matches another cell value vba : <p>Does anyone know how i might select any cell in a range that matches another?
for Example:</p>

<p>comparing range ("A9:A200") to range("B9")</p>

<p>if say range ("A10") is "bellingham" and range ("B9") is also bellingham </p>

<p>I want A10 to be the active cell. </p>

<p>any help would be most apreciated. thank you.</p>
