Shape.CopyPicture method (Excel)

Copies the selected object to the Clipboard as a picture.


expression.CopyPicture (Appearance, Format)

expression A variable that represents a Shape object.


Name Required/Optional Data type Description
Appearance Optional Variant An XlPictureAppearance constant that specifies how the picture should be copied. The default value is xlScreen.
Format Optional Variant An XlCopyPictureFormat constant that specifies the format of the picture. The default value is xlPicture.


If you copy a range, it must be made up of adjacent cells.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.