title: Find Address and Sum Address Values
body: <p>I'm doing a search in my sheet to find a Project Number. After I find it, I'll need to select 14 rows below its address and copy to another sheet. I can find the address were my search was, but I can't select the rows I need. Here's a part of my code</p>
  
  <pre><code>If opcao = True Then
      For i = 1 To 200
          If ws.Cells(i + 1, 1) = valor_busca Then
              correto = ws.Cells(i + 1, 1).Address
              Debug.Print correto, correto_1
          End If
      Next
  End If
  </code></pre>