Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Copies rows from one worksheet to another.
Syntax
public void insertRows(
int _fromRow,
int _toRow,
[int _fromWorkSheet,
int _offset,
int _numOfCopies,
int _toWorkSheet])
Run On
Called
Parameters
- _fromRow
Type: int
The top row to be copied.
- _toRow
Type: int
The bottom row to be copied.
- _fromWorkSheet
Type: int
The worksheet with original rows.
- _offset
Type: int
The offset for rows, if any rows are inserted after the current row.
- _numOfCopies
Type: int
The number of times rows should be copied.
- _toWorkSheet
Type: int
The destination worksheet.
Remarks
Merged cells are copied only if they are fully within copied rows, and if they do not intersect with merged cells in the destination worksheet.