Copy method has one argument - the destination range for the copy operation : Range Copy Cut Paste « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Range Copy Cut Paste

Copy method has one argument - the destination range for the copy operation

 
Sub CopyOne()
      Worksheets("Sheet1").Activate
      range("A1").Copy range("B1")
End Sub








Related examples in the same category

1.Copy method can use an argument that represents the destination for the copied range.
2.To copy a range to a different worksheet or workbook, simply qualify the range reference for the destination.
3.Copying a variably sized range
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