Calculate Event

Applies To

Chart object, Worksheet object.

Description

Chart object: Occurs after the chart plots new or changed data.

Worksheet object: Occurs after the worksheet is recalculated.

Syntax

Private Sub object_Calculate( )

object Chart or Worksheet.

See Also

Change event, SheetCalculate event.

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