Worksheet Change Event Query

[robcarr]

Dear All,

How can i get the worksheet change event to only trigger on cells a2:af51, any other cells and it ignores them.

Thanks

Thanks Rob.

 

[combo]

It is possible to trap changed cells:

[tt]Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A2:AF51&quot) Is Nothing Then
MsgBox "Range changed!"
End If
End Sub[/tt]

combo