Is there another way of finding if cells change in a worksheet other than the following?
Private Sub Worksheet_Change(ByVal Target as Range) If Target.Address=$A$1 Then 'something End If End Sub
What I'm particularly interested in is if there's a way of checking without
Target in the brackets at the beginning, as in, I would need a code with the
Private Sub() End Sub structure (nothing in the brackets is required for my code because I want to make a button with this function).