R
RobG2007
Below is my code for changing a value in a cell depending on what values are
in a range of rows.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo ErrHandler
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("C2:C20")) Is Nothing Then
Range("E63") = (Range("C63") - Target.Value)
End If
ErrHandler:
Application.EnableEvents = True
End Sub
But is it possible to miss out certain rows of the range for example
my range is A1:A100 but i dont want to include A23 and A25 is this possible
in a range of rows.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo ErrHandler
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("C2:C20")) Is Nothing Then
Range("E63") = (Range("C63") - Target.Value)
End If
ErrHandler:
Application.EnableEvents = True
End Sub
But is it possible to miss out certain rows of the range for example
my range is A1:A100 but i dont want to include A23 and A25 is this possible