Shape.CopyPicture (Excel)

Copies the selected object to the Clipboard as a picture.

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

CopyPicture (Appearance, Format)

Dim shp As Shape: Set shp = 
shp.CopyPicture

Arguments

Optional arguments

The following arguments are optional

Appearance (XlPictureAppearance) - An XlPictureAppearance constant that specifies how the picture should be copied. The default value is xlScreen.

Possible return values are xlPrinter - The picture is copied as it will look when it is printed, xlScreen - The picture is copied to resemble its display on the screen as closely as possible.

Format (XlCopyPictureFormat) - An XlCopyPictureFormat constant that specifies the format of the picture. The default value is xlPicture.

Possible return values are xlBitmap - Picture copied in bitmap (raster) format: bmp, jpg, gif, png, xlPicture - Picture copied in vector format: emf, wmf.