Workbook.SheetCalculate event (Excel)
Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
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.
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
With Worksheets(1)
.Range("a1:a100").Sort Key1:=.Range("a1")
End With
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.