| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculate in VBA
How do I force a recalculation in VBA ? Thanks.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recalculate in VBA
Use Calculate method
To calculate All open workbooks - Application.Calculate (or just Calculate) A specific worksheet - Worksheets(1).Calculate A specified range - Worksheets(1).Rows(2).Calculate or Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate "dhstein" wrote: How do I force a recalculation in VBA ? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recalculate in VBA
Sub stein001()
Application.Calculate End Sub -- Gary''s Student - gsnu200854 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recalculate in VBA
Thanks Gary and Sheeloo "Sheeloo" wrote: Use Calculate method To calculate All open workbooks - Application.Calculate (or just Calculate) A specific worksheet - Worksheets(1).Calculate A specified range - Worksheets(1).Rows(2).Calculate or Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate "dhstein" wrote: How do I force a recalculation in VBA ? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts recalculate to 100% | Charts and Charting in Excel | |||
| Recalculate changes only | Excel Discussion (Misc queries) | |||
| Auto recalculate? | Excel Worksheet Functions | |||
| Won't recalculate | Excel Discussion (Misc queries) | |||
| will not recalculate | Excel Worksheet Functions | |||
Linear Mode
