Is it possible to make it only apply to a change in one particular cell (A1)
instead of any cell on the spreadsheet? Thanks alot.

If Target.Address = "$A$1" Then
'do something
End If

Hth,
Merjet