You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
Description
Adds the specified Shape object to the Shapes collection.
Parameters
shape
The
Shape
object to add to the collection.
In Office File Format 2007 (.xlsx, .xlsm, etc) files, this will create a copy of the shape and add it to the worksheet. This allows you to add a shape from one workbook to a different workbook, or to create a copy of the shape within a single workbook. The shape's settings will be preserved, and the new shape will be located at the same location in the new worksheet as the original shape was located in its worksheet. If you wish to move it, you can set the
Shape.Position property to a new location within the worksheet.