title: VBA code works only in the debugging mode and hangs when running in normal mode
body: <p>This problem is driving me crazy. I have the following code:</p>
  
  <pre><code>'unprotect sheet
  If.Range("Start").Row+1&lt;.Range("End").Row then
    .Rows(.Range("Start").Row+1 &amp; ":" &amp; .Range("End").Row-1).Select
    Selection.Delete Shift:=xlUp
    'protect sheet
  End if
  </code></pre>
  
  <p>when I run it in debugging mode and trace the code, it works perfectly. But when run the code in a normal mode (not debugging) it gives me an error message as " select method of Range class failed" This errors happens in the line: <code>.Rows(.Range("Start").Row +1 ....</code>
  that is just after the IF statement. 
  Any ideas? 
  Please help.</p>