one way:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("J8:BL8")) Is Nothing Then
'Your code here
End If
End Sub


In article ,
John wrote:

I would only like the Change Event to kick in when i make a change in Cells
J8:BL8.
Programatically how would i write this please?

Thanks

John