Add watch : Watch « Excel « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Excel
3. Watch

Add watch

 

Sub AddWatch()

    With Application
        .Range("A1").Formula = 1
        .Range("A2").Formula = 2
        .Range("A3").Formula = "=Sum(A1:A2)"
        .Range("A3").Select
        .Watches.Add Source:=ActiveCell
    End With

End Sub

 

Related examples in the same category