Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Copy method can use an argument for the destination range
Sub CopyCurrentRegion2()
    Range("A1").CurrentRegion.Copy Sheets("Sheet1").Range("A1")
    Application.CutCopyMode = False
End Sub