The cells and shapes of Excel sheet belong to separate Object collections. We cannot refer to the shapes in a worksheet by using Cell ranges. We have to refer to them as part of Shapes Range or collection.

If all the shapes on your worksheet are to be included for copying on to another worksheet, then a macro can be easily written. Otherwise, we will have to refer them individually and copy them.

Also, note that when copying a shape from one sheet to another, the position of the shapes will change.