Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to determine the calculation setting of Excel from within a
macro? I write a lot of macros that turn off calculation so they'll run faster, then turn it back on at the end. Now I'm dealing with workbooks where automatic calculation is already turned off, and for those I don't WANT it turned on at the end. Is there a way to tell what the setting is so that I can set it back the way it was when the macro's done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Setting Manual Calculation on Specific Cells Only | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Auto Calculation Setting | Excel Discussion (Misc queries) | |||
Calculation to determine days between two dates | Excel Worksheet Functions |