View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Casey[_73_] Casey[_73_] is offline
external usenet poster
 
Posts: 1
Default Run Time error 424 Object Required


Jim,
Thanks. I not very good at anticipating errors and coming up with ways
to handle them yet. I often overlook that stuff. Question; since I have
an Error handler that goes to RET, do I still need the extra? And if I
do, should I exit to RET to reset ScreenUpdating? Something like:

If rng4 Is Nothing Then
MsgBox "Sorry, The item was not found"
GoTo RET 'instead of End Sub?????
End If


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=532338