View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrea[_8_] Andrea[_8_] is offline
external usenet poster
 
Posts: 5
Default Interrupting a loop

I have a macro that loops and within the loop produces and
emails a variety of workbooks. The process can take 15-20
minutes. Is there a graceful way to interrupt the loop at
a set interval other than pressing the escape key and
hoping for the best.

Thank you