Spreadsheet.Copy

This function copies the selected area in the spreadsheet.

Syntax Parameters Return Value
- This function has no parameters. This function does not return a value.

SVB Example

Copying a spreadsheet: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the activespreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'selects all of the cells in the spreadsheet
    spr.SelectAll()
    'copies the selected are specified by the SelectAll
    spr.Copy()
    Dim Rprt As Report
    'creates a new report and assigns it to the object Rprt
    Set Rprt = Reports.New
    'sets the Report to Visible
    Rprt.Visible = True
    'pastes copied cells into the report
    Rprt.Paste()
End Sub