Cut Method [Excel 2003 VBA Language Reference]

  • Article

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

expression**.Cut(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.

Remarks

The cut range must be made up of adjacent cells.

Only embedded charts can be cut.

Example

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

Worksheets("Sheet1").Range("A1:G37").Cut

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

See Also | Copy Method | Paste Method