Recalculate in VBA

  • Thread starter Thread starter dhstein
  • Start date Start date
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
 
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
 
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
Click to expand...
 
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Created Worksheet Function Not Recalculating 5
recalculation not recalculating some cells containing user functio 2
VBA syntax 6
Worksheet recalculation via VBA? 1
Calculation performance 2
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2
Which version have smart recalculation engine? 1
How do you do the following using VBA macro automatically? 1

Back
Top