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