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

--
Jim
"gazza67" wrote in message
ups.com...
| 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
|