title: VBA Progress update in Status bar stops updating at exactly row 327 every time
body: <p>I've created for loops in vba which update progress in status bar by the value of loop integer.
  There are 2 loops; progress in one loop works perfectly fine <strong>while in other it gets stuck though both are almost replicas</strong>. Tried different files, rebooting, closing excel etc, every time it <strong>stucks at row 327.</strong> idk why, row 327 is not special, in different files too <strong>it's always row 327.</strong> <strong>It's also not working so fast that it could be left behind.</strong> loop goes through thousands of rows and with time gets pretty slow, so it moves like <strong>one row in one second</strong>; that shouldn't be too fast to update status bar simultaneously. <strong>More Strange behavior is</strong> that when it goes to next workbook after completing one file, <strong>first loop still updates the progress bar again</strong>, but second loop again gets stuck at row 327.</p>
  <p><em>I couldn't attach full code here, it's more than 800 lines, even this module is 320 lines so I attached a sample here.</em></p>
  <p><em>(overall code works perfect, it's only the progress bar which gets stuck)</em></p>
  <pre><code>for i = 2 to lastrow
  Application.StatusBar = Round((i * 100) / lastrow, 0) &amp; &quot;% row &quot; &amp; i &amp; &quot; of &quot; &amp; lastrow
  
      if i mod 2 = 0 then
         'my code here
      else
         'my code here
      end if
  next 
  
  for x = 2 to lastrow
  Application.StatusBar = Round((x * 100) / lastrow, 0) &amp; &quot;% row &quot; &amp; x &amp; &quot; of &quot; &amp; lastrow
  
      if x mod 2 = 0 then
         'my code here
      else
         'my code here
      end if
  next 
  </code></pre>