Excel.Workbook.SheetCalculate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.SheetCalculate event (Excel)	vbaxl10.chm503090	vbaxl10.chm503090	Excel.Workbook.SheetCalculate	0610bfa5-15dc-a57f-f362-cf897bd54b91	05/29/2019	medium

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

[!includeSupport and feedback]