View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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