Cut Method [Excel 2003 VBA Language Reference]

Cuts the object to the Clipboard or pastes it into a specified destination.


expression Required. An expression that returns an object in the Applies To list.

Destination   Optional Variant. Used only with Range objects. The range where the object should be pasted. If this argument is omitted, the object is cut to the Clipboard.


The cut range must be made up of adjacent cells.

Only embedded charts can be cut.


This example cuts the range A1:G37 on Sheet1 and places it on the Clipboard.


Applies to | ChartObject Object | ChartObjects Collection Object | OLEObject Object | OLEObjects Collection Object | Range Collection | Shape Object

See Also | Copy Method | Paste Method