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
Return to index