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

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
|

That was it, Thanks so much!!

Gary



On Sep 7, 2:44 am, "Jim Rech" wrote:
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
|