View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Andrew B[_3_] Andrew B[_3_] is offline
external usenet poster
 
Posts: 7
Default Worksheet change subs.

Yes.
In the private sub test for the required range and proceed if it is correct.
e.g.
Private Sub SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

If Target.Count 1 Then Exit Sub

If Not Intersect(Target, Range("C5:J5")) Is Nothing then ' C5:J5
represents the range you want.

....your routine

end if


end sub

HTH
Andrew Bourke



"Erik" wrote in message
...
Is it possible to trigger a Private sub worksheet change for one range and

not another in the same worksheet?
Erik