Reference>IXLSRange>Move :: Delphi + Excel

Moves a cell or a range of cells to the specified range.

Syntax

procedure Move(Destination: IXLSRange);

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.

MoveMode can be one of these XlPasteType constants.

xlPasteAll

xlPasteFormats

xlPasteValues

xlPasteColumnWidths

xlPasteNumberFormats

xlPasteValuesNumberFormats

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.

With Workbook.Sheets[1] do begin 
   Range['A1', 'D4'].Move(Range['E5', 'H8'], xlPasteValues);
end;