| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy as Picture takes up to 5 seconds to copy
I'm using the following piece of code to copy a ChartObject as a picture.
myChtObj.CopyPicture appearance:=xlPrinter, Format:=xlPicture I'm also using this to copy a range as a picture myRange.CopyPicture appearance:=xlPrinter, Format:=xlPicture The median time to copy a chart is 9 seconds and a range of cells is 6 seconds. This seems quite excessive. Has anyone seen this before and what should I do. Execution is taking FOREVER. FWIW, it's taking me a long time to hide columns when I have all the application ... stuff disabled. Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy-Paste function takes forever | Excel Discussion (Misc queries) | |||
| Saving takes 30 Seconds | Excel Discussion (Misc queries) | |||
| Copying single cell takes 15-20 seconds | Excel Discussion (Misc queries) | |||
| my sheet takes too long to copy as it has macros | Excel Discussion (Misc queries) | |||
| Save takes seconds vs. SaveAs/Save As takes minutes | Excel Programming | |||
Threaded Mode
