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