Hi, I have a macro that copies some cells (which contain formulas) and pastes the values into a new line further down on the sheet. It works fine but I would like to have it paste the values into a separate sheet. I have tried various different code but can't get anything to work?

Hope someone can help?

Private Sub CommandButton1_Click()
Range("A1:D1").Select
    Selection.Copy
    Range("A100").Select
    ActiveCell.PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
    Selection.EntireRow.Insert
 
   
End Sub