title: For Each Sheet in Workbook.sheets - but in Reverse?
body: <p>I was using <code>For Each sheet In .Worksheets</code> for automating a report...and finally realized why the numbers on the first couple of sheets were off...they pull from later sheets.</p>
  
  <p>However, the order the sheets are in needs to be preserved, or at least restored, because this is how management uses them.  If I could go in reverse order while entering data, there shouldn't be a problem with sheet references. </p>
  
  <p>Is there a way to do <code>For Each sheet in .Worksheets Step -1</code> ??</p>
  
  <p>Or would I need to move the sheets around...loop through, enter data, run calcs...then move sheets back?  Or use the Index and loop backwards?  Any suggestions?</p>