Run-time error '1004' PasteSpecial Method of Range Class Failed
 

Hi,

I have a macro to copy a range from one sheet1 to sheet2. If a chart in
sheet2 is selected I get the following error.
Run-time error '1004' PasteSpecial Method of Range Class Failed

I would like to set up a error handling proceedure to either:
1) Notify user of chart being selected in sheet2 and then Exit Sub
or
2)Deselect chart in sheet2 and continue running macro

Can this be done?

Thanks, Kevin Graham

Run-time error '1004' PasteSpecial Method of Range Class Failed
 

Kevin

Activate the range in sheet2 you want to paste the data before doing the pastespecial
Something like
Range("a1:c1").Copy
Sheets("sheet2").Select
Range("a8").Activate
Range("a8").PasteSpecial Paste:=xlPasteValues
or
Range("a1:c1").Copy
Sheets("sheet2").Select
Range("a8").Select
Range("a8").PasteSpecial Paste:=xlPasteValues

Won't matter if the graph on sheet2 is selected or not as it will remove the focus.

Tony
----- Kevin G wrote: -----

Hi,

I have a macro to copy a range from one sheet1 to sheet2. If a chart in
sheet2 is selected I get the following error.
Run-time error '1004' PasteSpecial Method of Range Class Failed

I would like to set up a error handling proceedure to either:
1) Notify user of chart being selected in sheet2 and then Exit Sub
or
2)Deselect chart in sheet2 and continue running macro

Can this be done?

Thanks, Kevin Graham