Getting XL to work with only selected range

[Guest]

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

 

[JE McGimpsey]

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

 

[Guest]

Cool, thanks

John

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