In ms Excel

Question

which features calculate the whole worksheet if any changes made in single cell?

Answer 1

This has to be inserted in this worksheet:

Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$C$1" Then
MsgBox "calculate"
End If
End Sub

Answer 2

Jj