Select current range and copy : Copy Paste « Excel « VBA / Excel / Access / Word






Select current range and copy

 

Sub SelCurRegCopy()
    Selection.CurrentRegion.Select
    Selection.Copy
    Range("A17").Select ' Substitute your range here
    ActiveSheet.Paste
    Application.CutCopyMode = False
End Sub

 








Related examples in the same category

1.Overridden with the Destination parameter
2.Copy cells
3.Copy areas
4.Copy and Paste can be carried out entirely by the Copy method