Quote Originally Posted by cog38 View Post
Does the set ws1 = sheets need to include the other sheets - Debt, Terms of Trade, REER and FX?
No, the other ones should be covererd under the Case Else, since it is all the same actions in each of those sheets. However, I put it into a Select/Case format so in the future if you wanted to make special accomidation for a sheet you could easily specify it. Let me know if the above amended code works.