Moves a cell or a range of cells to the specified range.
Syntax
procedure Move(Destination:
IXLSRange; MoveMode: LongWord);
| Destination |
IXLSRange. Specifies the new range to which the specified range will be moved. |
| MoveMode |
Optional LongWord. The part of the range to be moved. Default is xlPasteAll. |
Description
MoveMode can be one of these XlPasteType constants.
| xlPasteAll |
| xlPasteFormats |
| xlPasteValues |
| xlPasteColumnWidths |
| xlPasteNumberFormats |
| xlPasteValuesNumberFormats |
Example
This example moves the range A1:D4 on Sheet1 into range E5:H8 on Sheet2.
Workbook.Sheets[1].Range['A1', 'D4'].Move(Workbook.Sheets[2].Range['E5', 'H8']);
This example moves the values of range A1:D4 on Sheet1 into range E5:H8 on the same sheet.