Workbook.SheetCalculate Event

Syntax

expression.SheetCalculate(Sh, )

expression An expression that returns a Workbook object.

Parameters

Name	Required/Optional	Data Type	Description
Sh	Required	Object	Can be a Chart or Worksheet object.

Example

This example sorts the range A1:A100 on worksheet one when any sheet in the workbook is calculated.

Visual Basic for Applications
`Private Sub Workbook_SheetCalculate(ByVal Sh As Object) With Worksheets(1) .Range("a1:a100").Sort Key1:=.Range("a1") End With End Sub`

Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.