Macro Sheets Only
Equivalent to choosing the Copy Picture command from the Edit menu. The Copy Picture command appears if you hold down SHIFT while choosing the Edit menu. It copies a chart or range of cells to the Clipboard as a graphic. Use COPY.PICTURE to create an image of the current selection or chart for use in another program.
Syntax
COPY.PICTURE(appearance_num, size_num, type_num)
COPY.PICTURE?(appearance_num, size_num, type_num)
Remarks
Graphics are created differently on screen and on a printer. Thus, the printed picture may look different from the one on screen.
Appearance_num is a number describing how to copy the picture.
Appearance_num Action
1 or omitted Copies a picture as closely as possible to the picture displayed on your screen
2 Copies what you would see if you printed the selection
Size_num is a number describing how to copy the picture and is only available if the current selection is a chart.
Size_num Action
1 or omitted Copies the chart in the same size as the window on which it is displayed
2 Copies what you would see if you printed the chart
Type_num is a number specifying the format of the picture. This argument is available only in Microsoft Excel for Windows.
Type_num Format of the picture
1 or omitted Picture
2 Bitmap
Related Functions
COPY Copies and pastes data or objects
CUT Cuts or moves data or objects
PASTE Pastes cut or copied data
PASTE.PICTURE.LINK Pastes a linked picture of the currently copied area
PASTE.SPECIAL Pastes specific components of copied data
List of Command-Equivalent Functions