| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forced recalculation in Excel
Hi all
I find that Excel does not always calculate properly when pressing F9. I have been shown the trick with Ctrl-Alt-F9, which forces a recalculation of all formulas in all open files and sheets. Is there an equivalent to this in VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Forced recalculation in Excel
Claude,
In Excel 2000 and later, use Application.CalculateFull In Excel 2002 and later, you can also use Application.CalculateFullRebuild -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Claude" wrote in message ... Hi all I find that Excel does not always calculate properly when pressing F9. I have been shown the trick with Ctrl-Alt-F9, which forces a recalculation of all formulas in all open files and sheets. Is there an equivalent to this in VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Forced Word Wrap | New Users to Excel | |||
| how do I insert forced linebreaks in cells in Excel | Excel Discussion (Misc queries) | |||
| Forced new line in a cell: Excel | Excel Discussion (Misc queries) | |||
| Forced Cell Input in Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel Option Buttons: getting forced choices per row, not per w/s | Setting up and Configuration of Excel | |||
Linear Mode
