Shape.CopyPicture Method (Excel)

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

Concepts

Shape Object Members

Shape Object