Cut Method

Microsoft Excel Visual Basic

Cut Method

       

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