CODEWITHSUNDEEP
excelvba
gregg2597
gregg2597

Reputation: 1

Use the calculate function in a macro

I can make a macro emulate the calculate manual F9 key, but it only loops once. So I'd like to write a macro that emulates holding down the F9 key to calculate the worksheet in a continuous loop.

Upvotes: 0

Views: 3245

Answers (1)

Pᴇʜ
Pᴇʜ

Reputation: 57673

If you need to run calculation with VBA use the Application.Calculate Method (Excel).

  • All open workbooks Application.Calculate
  • A specific worksheet Worksheets("sheetName").Calculate
  • A specified range Worksheets("sheetName").Range("A1:C3").Calculate

Upvotes: 2

Related Questions