Getting XL to work with only selected range
 

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

Getting XL to work with only selected range
 

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

Getting XL to work with only selected range
 

Cool, thanks

John

"JE McGimpsey" wrote:

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