title: Copy row to another sheet in excel using VBA
body: <p>First off, I have never used VBA (or VB for that matter), so keep that in mind. I am trying to copy a row to another sheet in my workbook. So whenever any change in row 2 will happen in sheet1, that row should be copied in row 2 on sheet2. If row 3 is modified in sheet1, row 5 should be modified on sheet2. I want there to be an empty row between each row on sheet2. I am going to try and create a new table with VBA to place inside this empty row. Anyways, I am getting an error on my Selection.Paste line. I have very limited knowledge (an hours worth) on VBA, so I could be completely off on what I am trying to do.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
   'Do not worry about column headers
    If Target.Row = 1 Then Exit Sub
  
    'On Error GoTo ErrHandler
    Application.EnableEvents = False 'This might be necessary?
  
    Sheet1.Rows(Target.Row).Select
    Selection.Copy
    Sheet1.Rows(Target.Row).Copy
  
    If Target.Row = 2 Then
      Sheet2.Rows(Target.Row).Select
      Selection.Paste
    Else
      Sheet2.Select
      Sheet2.Rows(Target.Row + Target.Row - 1).Select
      Selection.Paste
    End If
  
  ErrHandler:
    Application.EnableEvents = True 'This might be necessary?
  End Sub
  </code></pre>
  
  <hr>
  
  <p><strong>Edit:</strong> After changing <code>Selection.Paste</code> to <code>ActiveSheet.Paste</code>, it is now working.</p>