Thread: Error Trapping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gazza67[_2_] gazza67[_2_] is offline
external usenet poster
 
Posts: 8
Default 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