No debug option in VBA runtime error <p>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?</p> <p>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.</p> <p>screenshot of error -</p> <p>Code is as follows -</p> <pre><code>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 </code></pre> <p>Screenshot of the error <a href="https://imgur.com/gC32z74" rel="nofollow noreferrer">http://imgur.com/gC32z74</a></p> <p><img src="https://i.stack.imgur.com/fwXVf.png" alt="enter image description here"></p>