copy and paste in VBA from specific column into another sheet

[joda89]

Whats a simple code for copying columns (A2, B2, C2) from sheet 1 into Cells on sheet 2 (A7, B7, C7) needing this for a macro and adding a command button that just copies it.

 

[joda89]

It has to be in VBA

 

[My Aswer Is This]

Try this:

Sub Copy_Range()
Sheets(1).Range("A2:C2").Copy Sheets(2).Range("A7")
End Sub

 

[JackDanIce]

Alternatively, if you want to avoid copying to and paste from clipboard and then clearing the copied values on the clipboard, you can use following if you just want Sheet 2 values to be same values as Sheet 1, i.e.:

Sub Copy_Rng()
Sheets("Sheet2").Range("A7:C7").Value = Sheets("Sheet1").Range("A2:C2").Value
End Sub