ExcelBanter - Recalculate in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Recalculate in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/231826-recalculate-vba.html)

dhstein

Recalculate in VBA

How do I force a recalculation in VBA ? Thanks.

Sheeloo

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.

Gary''s Student

Recalculate in VBA

Sub stein001()
Application.Calculate
End Sub
--
Gary''s Student - gsnu200854

dhstein

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.

All times are GMT +1. The time now is 07:01 AM.