Spreadsheet.Paste

This function pastes the contents of the Clipboard into the selected area of the spreadsheet.

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

SVB Example

Pasting data into a spreadsheet: 

Option Base 1
Option Explicit
Sub Main
    'copy and paste data from one spreadsheet to another
    ActiveSpreadsheet.SelectAll
    ActiveSpreadsheet.Copy

    Dim spr As New Spreadsheet
    spr.SetSize(ActiveSpreadsheet.NumberOfCases, ActiveSpreadsheet.NumberOfVariables)
    spr.SelectAll
    spr.Paste 'paste in the data from the other spreadsheet
    spr.Visible = True
End Sub