Compartilhar via

Worksheet.Calculate Event

  • Artigo
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