| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyPicture Method and "Picture/BitMap" Format
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| method "range" of object "_worksheet" fails | Excel Programming | |||
| how to prevent a bitmap from "bleeding" over two pages? | Excel Programming | |||
| Error Help - Method "Range" of object "_Worksheet" failed. | Excel Programming | |||
| What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
Threaded Mode
