title: Excel VBA Looping a continuous copy/paste with delay
body: <p>I already have code below which successfully copy and pastes one row on Sheet1 to the next open row on Sheet2.  The data on this row is imported from an external application and updates constantly, thereby creating a history writer.  I have attempted several methods to loop this action with a delay and have failed.  </p>
  
  <p>GOAL: Loop this code with .25 second delay with the option to exit the loop with a button click or key-press.  The delay is more important than the exit condition as I can just Esc if need be.</p>
  
  <pre><code>Private Sub START_Click()
  
      Application.ScreenUpdating = False
      Dim copySheet As Worksheet
      Dim pasteSheet As Worksheet
  
      Set copySheet = Worksheets("Sheet1")
      Set pasteSheet = Worksheets("Sheet2")
  
      copySheet.Range("A23:L23").Copy
      pasteSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
      Application.CutCopyMode = False
      Application.ScreenUpdating = True
  
  
  End Sub
  </code></pre>