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 |
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