Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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