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