VBA Calc

[Michael Singmin]

Hello Group,

What is the equivalent of Calc (F9) in VBA ?

My application has a lot of complex array entered formulas
so I keep the calculation set as manual.

When new data values are entered and the database sorted,
I would like to do a recalculation so the array formaulas can be
updated.

Thanks,

Michael Singmin

 

[Frank Kabel]

Hi
application.calculate

 

[Bob Phillips]

Michael,

Is your work in VBA. If so, doesn't reseting the calculation mode

Application.Calculation= xlCalculationAutomatic

automatically recalculate for you

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Harald Staff]

Hi Michael

Adding to the others; there are a few levels of this. If your app is Very Big then you may
want to calculate as little as possible to speed it up.

Sub CalcStuff()
Range("B1").Calculate
Rows(1).Calculate
Columns(2).Calculate
Sheets(1).Calculate
Application.Calculate
End Sub

There are keystroke equivalents for most of this too, mumbo-jumbo-F9 rituals that I never
remember the flavors of.

 

[Michael Singmin]

Thanks to all of you,

The application.calculate works for my project.

The other ideas will come in very useful in the future.

Michael
==========================================================