title: How do I yield to the message pump in Excel VBA 2010?
body: <p>I have an Excel macro that takes an exceedingly long time.  It seems to crash Excel (I get a Not Responding message in the taskbar) when I leave it unattended, but if I put a breakpoint that gets hit every five or ten seconds, it's OK.  Trouble is, I'll need to step on from the breakpoint about a quarter of a million times (we're looking at about 200 hours to execute this beast)</p>
  
  <p>I'm guessing that the absence of message pump activity is antagonising the kernel, so how might I flush the message queue?  Or am I barking up the wrong tree entirely?</p>
  
  <p>I'm very new to this, by the way, so documentation references will be very welcome.</p>
  
  <p>Cheers,
  Guy</p>