title: Excel VBA find first value row in range
body: <p>I have this range it selects all values in that column:</p>
  
  <p><code>Set c = ThisWorkbook.Worksheets("SplitSkillInterv").Range("C3:C" &amp; Rows.Count)</code></p>
  
  <p>Now I need to make it to find some value and then its row (it could be 1 or 10+, so I need to find first one) any ideas? </p>
  
  <p>I need to find for example: in range c values are from 1 to 10 and randomly repeating till total 100 rows. I and lets say i need to find when first time will be number 3 in range and its row.   </p>