title: Cycle Through Excel Worksheets and Pausing Each One
body: <p>I am trying to do something which should be relatively simple but I just cant get it working correctly, I keep killing Excel.</p>
  
  <p>I have a workbook with several sheets containing data, pivots and charts. I want to cycle between a select number of sheets, which I have managed to do, code below, but what I am trying to achieve now is to get it to pause for say 10 seconds on each sheet before moving to the next sheet.</p>
  
  <pre><code>Sub LoopThroughFlaggedSheets()
  
  Dim StartIndex, EndIndex, LoopIndex, CountIndex As Integer
  
  StartIndex = Sheets("Dashboard").Index
  EndIndex = Sheets("Sales By Policy Type").Index
  CountIndex = 5
  
  For CountIndex = 1 To CountIndex
      For LoopIndex = StartIndex To EndIndex
          MsgBox Sheets(LoopIndex).Name
  
      Next LoopIndex
  Next CountIndex
  End Sub
  </code></pre>
  
  <p>So at present it loops 5 times through the worksheets between Dashboard and Sales By Policy Type, the messagebox is just for me so I know what its doing. I just need it to pause for whatever specified time period between each sheet. I know something needs to go within the LoopIndex loop but I cannot for the life of me figure out where and which command.</p>
  
  <p>Cheers</p>