Worksheet.Calculate Event

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

See Also

• Worksheet Object
• Worksheet Object Members