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. |