title: excel VBA trying to get my macro to run faster
body: <p>I am trying to get my macro to run a bit faster and i was wondering which way is the fastest:</p>
  
  <p>1)</p>
  
  <pre><code>Set cell2 = Range("F" &amp; CurrentRow)
  Set Columns = Range(cell2, cell2.Offset(0, LastColumn - 6))
  i = 0
  For Each cell In Columns
  If cell.Value = " - " Then
  Else
      ...code...
  Next cell
  </code></pre>
  
  <p>2)</p>
  
  <pre><code>Set cell2 = Range("F" &amp; CurrentRow)
  CurrentColumn=6
  While CurrentColumn &lt;= LastColumn
       Cells(CurrentColumn,CurrentRow).Value...code...
       CurrentColumn = CurrentColumn+1
  Wend
  </code></pre>
  
  <p>And is there a faster way than these two?</p>
  
  <p>Thanks in advance,
  Bruno</p>