Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As I read the help,
F9 Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL+F9 minimizes a workbook window to an icon. Is there some way to force Excel to recalculate just one cell without recalculating anything else? I have a sheet that calls a VBA function from a lot of different cells. If I put a trace or msgbox in the function for debugging, I don't want it to run 50 times. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 set a row or column to not recalculate | Excel Worksheet Functions | |||
Can I force my UD Functions to recalculate? | Excel Programming | |||
How to force user function to recalculate | Excel Programming | |||
How to force all of the cells in a worksheet to recalculate? | Excel Programming | |||
VBA: Force wait until recalculate | Excel Programming |