Shape.CopyPicture Method

Excel Developer Reference

Copies the selected object to the Clipboard as a picture.

Syntax

expression.CopyPicture(Appearance, Format)

expression   A variable that represents a Shape object.

Parameters

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

Remarks

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

See Also