영어로 읽기

다음을 통해 공유


Worksheet.Calculate Event (Excel)

Occurs after the worksheet is recalculated, for the Worksheet object.

Syntax

.Calculate

A variable that represents a Worksheet object.

Return Value

nothing

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

참고 항목

개념

Worksheet Object

Worksheet Object Members