Cut Method

Applies To

Arc Object, Arcs Collection, Button Object, Buttons Collection, ChartObject Object, ChartObjects Collection, CheckBox Object, Drawing Object, DrawingObjects Collection, Drawings Collection, DropDown Object, DropDowns Collection, EditBox Object, EditBoxes Collection, GroupBox Object, GroupBoxes Collection, GroupObject Object, GroupObjects Collection, Label Object, Labels Collection, Line Object, Lines Collection, ListBox Object, ListBoxes Collection, OLEObject Object, OLEObjects Collection, OptionButton Object, OptionButtons Collection, Oval Object, Ovals Collection, Picture Object, Pictures Collection, Range Object, Rectangle Object, Rectangles Collection, ScrollBar Object, ScrollBars Collection, Spinner Object, Spinners Collection, TextBox Object, TextBoxes Collection.

Description

Cuts the object to the Clipboard or to a specified destination.

Syntax

object.Cut(destination)

object

Required. The object to cut.

destination

Optional (used only with Range objects). Specifies the range where the object should be pasted. If omitted, the object is cut to the Clipboard. The destination range must be a single cell or an enlarged multiple of the range to be cut.

Remarks

The cut range must be made up of adjacent cells.

Only embedded charts can be cut.

See Also

Copy Method, Paste Method.

Example

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


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