CODEWITHSUNDEEP
vbadebuggingerror-handling
waggy123
waggy123

Reputation: 31

No debug option in VBA runtime error

I am using excel 2013. I do not get any debug option when there is a runtime error. How can I get a debug option during runtime errors?

Edit - I have realized that I have this problem only in the following instance. Normally I am getting the debug option (except for this case). What is especially painful is that it doesn't even tell me which line the error is on.

screenshot of error -

Code is as follows -

Option Explicit
Option Base 1

Sub doit()

Dim intRowCounter As Long
Dim intColCounter As Long
Dim parentFormula As String
Dim resultantFormulas As String

For intRowCounter = 1 To 100
    For intColCounter = 1 To 200

        'This is the line giving the error
        parentFormula = Right(parentFormula, Len(parentFormula) - 1)

    Next intColCounter
Next intRowCounter

End Sub

Screenshot of the error https://i.sstatic.net/fndsc.jpg

enter image description here

Upvotes: 3

Views: 7812

Answers (2)

ivan_pozdeev
ivan_pozdeev

Reputation: 35998

In VBA editor, Tools->Options... menu, General tab in the resulting dialog, set "Break on All Errors":

enter image description here

Upvotes: 2

Doug
Doug

Reputation: 31

I came across this thread because I had a spreadsheet where I didn't get a debug option when a macro hit an error. I found that if I make a module and put the same sub in the module instead of the Worksheet then I get the debug option when an error occurs.

If I leave the function in the Worksheet I can set the Options differently. If I leave it on "Break on Unhandled Errors" I only get an error message, if I make it "Break on All Errors" or "Break in Class Module" then I get the debug option when an error occurs.

Upvotes: 3

Related Questions