f9 in vba

[lior03]

hello
i am trying to figure out how do i make excel , in vba terms calculate the entire worksheet.
to be specific - i took some action and i want to refrain from using the f9 button,can i make my macro take the action i want and then recalculate the entire worksheet.
thanks

[Jacob Hilderbrand]

Sheets("Sheet1").Calculate
Sheet1.Calculate
Sheets(1).Calculate

[Cyberdude]

For a little more on this subject, you might want to review the Calculate Method in the VBA Help.

[Erdin? E. Ka]

Also you can check CalculateFull Method in VBA help.

Taken From VBA Help:


Sub CalculateFullMethod()
If Application.CalculationVersion <> Workbooks(1).CalculationVersion Then
Application.CalculateFull
End If
End Sub