Worksheet.Calculate Event (Excel)
Occurs after the worksheet is recalculated, for the Worksheet object.
Syntax
expression .Calculate
expression A variable that represents a Worksheet object.
Return Value
nothing
Example
This example adjusts the size of columns A through F whenever the worksheet is recalculated.
Private Sub Worksheet_Calculate()
Columns("A:F").AutoFit
End Sub