Share via


Worksheet.Calculate Event

Excel Developer Reference

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.

Visual Basic for Applications
  Private Sub Worksheet_Calculate()
    Columns("A:F").AutoFit
End Sub

See Also