Dear All,

I have one cell in a worksheet and I want to fire a Macro
when this particular cell changes but not when other
cells change within the same sheet. It would be useful to
know how I can do the same for a range too. Any help is
appreciated. Thanks in advance.

Try something like this
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("a1:a1"), Target) Is Nothing Then
macrochange
End If
End Sub
Tina
" wrote:

Dear All,

I have one cell in a worksheet and I want to fire a Macro
when this particular cell changes but not when other
cells change within the same sheet. It would be useful to
know how I can do the same for a range too. Any help is
appreciated. Thanks in advance.