Range.Copy Method (Excel) - MSDN - Microsoft

If this argument is omitted, Microsoft Excel copies the range to the Clipboard. ... The following code example copies the formulas in cells A1:D4 on Sheet1 into ... VBA. Copy. Public Sub CopyRows() Sheets("Sheet1").Select ' Find the last row of &n

msdn.microsoft.com