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?