Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.
Syntax
'Declaration
Public Overloads Sub SetClipSpecial( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Object, _
ByVal As ClipboardPasteOptions, _
ByVal As Boolean, _
ByVal columnHeader As Boolean _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value As Object
Dim pasteOption As ClipboardPasteOptions
Dim rowHeader As Boolean
Dim columnHeader As Boolean
instance.SetClipSpecial(row, column, rowCount, columnCount, value, pasteOption, rowHeader, columnHeader)
Parameters
- row
- Starting row index of the range of cells (or -1 for all rows)
- column
- Starting column index of the range of cells (or -1 for all columns)
- rowCount
- Number of rows in the range of cells (or -1 for all rows)
- columnCount
- Number of columns in the range of cells (or -1 for all columns)
- value
- CellInfo object to set into the cells of the specified range
- pasteOption
- Clipboard paste option that determines what to paste
- rowHeader
- Whether to include row headers
- columnHeader
- Whether to include column headers
Exceptions
See Also