Calculate Event
From Microsoft Excel Visual Basic
Calculate Event
Occurs after the chart plots new or changed data, for the Chart object. Occurs after the worksheet is recalculated, for the Worksheet object.
Private Sub object_Calculate()
object Chart or Worksheet. For information about using events with the Chart object, see Using Events with the Chart Object.
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