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.
|