why does Excel not report VBA run-time errors

[OaklandJim]

I cannot figure out how to get Excel to tell me when there is a run-time error in my code. Code below does not throw up an error message.

Sub Junk()

With [Stuff].[Crap]

End With

If [Stuff].[Crap] Then Call Barf

End Sub

I BELIEVE that I have Options set correctly?

 

[RoryA]

That should raise an error when you run it.

 

[OaklandJim]

Indeed, that junk code should cause an error. I tried junk code in a new workbook and got error message. But in one specific workbook errors WERE not reported. BUT, after reopening the file error messaging works. That seems odd to me but hey, the guts of Excel have a mind of their own.

 

[Logit]

the guts of Excel have a mind of their own.

You betcha brother ! And it is tiring.