View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default "Object Required" not displaying

You probably have On Error statements which tells the code not to break when
it finds an error. Remove (or comment) the On Error statement.

"J@Y" wrote:

I have an Error 424 (Object Required) in my code. I have located where it is
using On Error method. But I don't understand why the code doesn't break
automatically to raise the error.