Copy Paste in VBA

Copy Paste Range


Sub CopyPaste()

    Range("A1").Select
    Selection.Copy
    Range("B1").Select
    ActiveSheet.Paste
    
End Sub




Copy Paste Worksheet


Sub CopyPasteSheet()

    Sheets("Sheet1").Select
    Sheets("Sheet1").Copy Before:=Sheets(1)

End Sub