Copies a range of cells and pastes it into a range of cells at the specified location.
Syntax
'Declaration
Sub Copy( _
ByVal As Integer, _
ByVal fromColumn As Integer, _
ByVal As Integer, _
ByVal toColumn As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer _
)
'Usage
Dim instance As IRangeSupport
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
instance.Copy(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)
Parameters
- fromRow
- Row index from which to begin copying
- fromColumn
- Column index from which to begin copying
- toRow
- Row index at which to paste the cell range
- toColumn
- Column index at which to paste the cell range
- rowCount
- Number of rows to copy
- columnCount
- Number of columns to copy
See Also