Copy method can use an argument that represents the destination for the copied range. : Range Copy Cut Paste « Excel « VBA / Excel / Access / Word






Copy method can use an argument that represents the destination for the copied range.

 
Sub CopyRange()
    range("A1").Copy range("B1")
End Sub

 








Related examples in the same category

1.To copy a range to a different worksheet or workbook, simply qualify the range reference for the destination.
2.Copying a variably sized range
3.Copy method has one argument - the destination range for the copy operation
4.The Copy and Paste methods
5.Copy a range
6.Moving a range
7.Moving a range: move a range by cutting it to the Clipboard and then pasting it in another area
8.You can move a range with a single VBA statement
9.Copy method can use an argument for the destination range