Single Sheet - Calculate Manually
Here you go! Just change the variable strSheetName to the name of the
sheet you mentioned. Sub CalculateAllExcept() strSheetName = "Sheet I don't want calculated" For Each sht In Sheets If sht.Name < strSheetName Then sht.Calculate End If Next sht End Sub --- Mark Bigelow http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com