title: Excel-VBA: Ignore hidden rows in a for loop
body: <p>I was searching for my problem .. but i couldn't find something good.</p>
  
  <p>Im trying to copy some values from sheet 1 to sheet 2.. 
  In sheet 1("xy") there are no hidden rows. In sheet 2("Adress") there are. </p>
  
  <p>I would use a for-loop to do that: </p>
  
  <pre><code>end = cells(rows.count, 1).end(xlUp).row
  Row = 1
  For i = 11 To end
      Sheets("xy").Select
      Cells(Row, 19).Copy
      Sheets("Adress").Select
      Cells(i, 19).PasteSpecial xlPasteValues
      Row = Row + 1
  Next i
  </code></pre>
  
  <p>The problem is that the loop is still using the hidden rows in sheet2("Adress") ... 
  How can I skip them ? </p>
  
  <p>Thanks for your help :) </p>