K
Kevin G
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
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