Shape Methods (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Methods
Name |
Description |
---|---|
Applies to the specified shape formatting that’s been copied by using the PickUp method. |
|
Copies the object to the Clipboard. |
|
Copies the selected object to the Clipboard as a picture. |
|
Cuts the object to the Clipboard. |
|
Deletes the object. |
|
Duplicates the object and returns a reference to the new copy. |
|
Flips the specified shape around its horizontal or vertical axis. |
|
Moves the specified shape horizontally by the specified number of points. |
|
Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape. |
|
Moves the specified shape vertically by the specified number of points. |
|
Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape. |
|
This method reroutes all connectors attached to the specified shape; if the specified shape is a connector, it’s rerouted. |
|
Scales the height of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height. |
|
Scales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width. |
|
Selects the object. |
|
Makes the formatting of the specified shape the default formatting for the shape. |
|
Ungroups any grouped shapes in the specified shape or range of shapes. Disassembles pictures and OLE objects within the specified shape or range of shapes. |
|
Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order). |