D
dhstein
How do I force a recalculation in VBA ? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sheeloo
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").Calculate
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").Calculate
G
Gary''s Student
Sub stein001()
Application.Calculate
End Sub
Application.Calculate
End Sub
D
dhstein
Thanks Gary and Sheeloo
Sheeloo said: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").Calculate