Cut Method

Microsoft Excel Visual Basic

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