Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?

Ben,

To have it only look at cell A2:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$2" Then Exit Sub
....


HTH,
Bernie
MS Excel MVP

"benb" wrote in message
...
Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?

Private Sub Worksheet_Change(ByVal Target As Range)

if target.address= "$A$1" Then
'etc.
End If

End Sub

--

HTH

RP

"benb" wrote in message
...
Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?