This documentation is archived and is not being maintained.

Worksheet.Calculate Event

Office 2007
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



Show: