Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

CopyPicture Method [Excel 2003 VBA Language Reference]

Office 2003

Copies the selected object to the Clipboard as a picture. Variant.

expression.CopyPicture(Appearance, Format)

expression Required. An expression that returns one of the above objects.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the screen as closely as possible

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

Copies the selected object to the Clipboard as a picture. Variant.

expression.CopyPicture(Appearance, Format)>

expression Required. An expression that returns one of the above objects.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the screen as closely as possible

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

Copies the selected object to the Clipboard as a picture.

expression.CopyPicture(Appearance, Format, Size)

expression Required. An expression that returns one of the above objects.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the screen as closely as possible

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter default. The picture is copied to match its printed size as closely as possible.
xlScreen. The picture is copied to match the size of its display on the screen as closely as possible.

Copies the selected object to the Clipboard as a picture.

expression.CopyPicture(Appearance, Format)

expression Required. An expression that returns one of the above objects.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the screen as closely as possible

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

Remarks

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

Example

This example copies a screen image of cells A1:D4 on Sheet1 to the Clipboard, and then it pastes the bitmap to another location on Sheet1.

Worksheets("Sheet1").Range("A1:D4").CopyPicture xlScreen, xlBitmap
Worksheets("Sheet1").Paste _
    Destination:=Worksheets("Sheet1").Range("E6")
		




Show:
© 2014 Microsoft