| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a template that is manually updated from another sheet. | Excel Worksheet Functions | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| How do I calculate the interest payment manually (without using IP | Excel Worksheet Functions | |||
| How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100 | Excel Worksheet Functions | |||
| is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
![Mark Bigelow[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
