Error Trapping

[gazza67]

Can someone tell me why the following falls over with a runtime error
when the clipboard is empty (ie I do not get the msgbox)

On Error Resume Next
ActiveSheet.Paste
If Err Then MsgBox "Nothing to paste!": Err.Clear

Thanks,
Gary

 

[Jim Rech]

Do you have Break on All Errors set under Tools, Options, General in the
VBE?

--
Jim
| Can someone tell me why the following falls over with a runtime error
| when the clipboard is empty (ie I do not get the msgbox)
|
| On Error Resume Next
| ActiveSheet.Paste
| If Err Then MsgBox "Nothing to paste!": Err.Clear
|
| Thanks,
| Gary
|

 

[gazza67]

That was it, Thanks so much!!

Gary