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

Hi
application.calculate

--
Regards
Frank Kabel
Frankfurt, Germany

Michael Singmin wrote:
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

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)

"Michael Singmin" wrote in message
...
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

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Michael Singmin" wrote in message
...
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

Thanks to all of you,

The application.calculate works for my project.

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

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

Michael Singmin wrote:

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