When you copy a range as a picture you make the appearance either "as shown
when printed" or "as shown on screen". When you chose "as shown when
printed" you can only chose the Picture format (i.e. not bitmap).

Worksheets("Sheet1").UsedRange.CopyPicture Appearance:=xlPrinter,
Format:=xlPicture

Why is that? What is the picture format Can it be converted to bitmp or
JPEG after the fact?

Thanks

EM

It is a bitmap . From help:...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")


If this post helps click Yes
---------------
Jacob Skaria


"ExcelMonkey" wrote:

When you copy a range as a picture you make the appearance either "as shown
when printed" or "as shown on screen". When you chose "as shown when
printed" you can only chose the Picture format (i.e. not bitmap).

Worksheets("Sheet1").UsedRange.CopyPicture Appearance:=xlPrinter,
Format:=xlPicture

Why is that? What is the picture format Can it be converted to bitmp or
JPEG after the fact?

Thanks

EM

I am not sure I understand your response. My example uses the "picture"
format NOT the "bitmap" format. I want to understand what the difference is
between the two formats and whether or not you can/need to convert from
"picture" to bitmap after the fact as you are not provided with the option to
use bitmap unless you use the "as seen on screen" option.

You example uses the "as seen on screen" and allows for both bitmap and
picture formats.

Thanks

EM

"Jacob Skaria" wrote:

It is a bitmap . From help:...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")


If this post helps click Yes
---------------
Jacob Skaria


"ExcelMonkey" wrote:

When you copy a range as a picture you make the appearance either "as shown
when printed" or "as shown on screen". When you chose "as shown when
printed" you can only chose the Picture format (i.e. not bitmap).

Worksheets("Sheet1").UsedRange.CopyPicture Appearance:=xlPrinter,
Format:=xlPicture

Why is that? What is the picture format Can it be converted to bitmp or
JPEG after the fact?

Thanks

EM