Copying a variably sized range : Range Copy Cut Paste « Excel « VBA / Excel / Access / Word

Copying a variably sized range

Sub CopyCurrentRegion2()
    range("A1").CurrentRegion.Copy Sheets("Sheet2").range("A1")
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.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