Thread
:
Error Trapping
View Single Post
#
1
Posted to microsoft.public.excel.misc
gazza67[_2_]
external usenet poster
Posts: 8
Error Trapping
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
Reply With Quote
gazza67[_2_]
View Public Profile
Find all posts by gazza67[_2_]