Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I have a worksheet where I am cycling through some pivot tables and copying a range defined by a range name to an output sheet. The range being copied includes a chart and a few rows of cells. I keep getting a Run-Time Error '1004': CopyPicture method of range class failed I believe the syntax is correct because if I use error code and use resume it will continue after 0 to <15 tries? Anyone have any experience with this issue? I have tried both options below: Range(strRangeName).CopyPicture Appearance:=xlScreen, Format:=xlPicture Worksheets(SourceSheetName).Range(strRangeName).Co pyPicture Appearance:=xlScreen, Format:=xlPicture |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CopyPicture method (# 1004) failed | Excel Programming | |||
PasteSpecial method for range class failed | Excel Programming | |||
Select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming | |||
Copypicture method failed | Excel Programming |