Hi, I have a script that works, but I need help expanding its use.
This is an accumulator, and it works, but I need it to also do the same thing on the same sheet but for different target and range. Just like with F3:F4 to "V",I need F6:F7 to produce a result on "W"
Any help would be great. I have mucked with it for several hours trying to get it to work.
Thanks
__________________________________________________________________
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Count >1 Then Exit Sub
If Not Intersect(Target, Range("F3:F4")) Is Nothing Then
With Target
If IsNumeric(.Value) Then
Application.EnableEvents = False
Range("V" & .Row).Value = Range("V" & .Row).Value + .Value
Application.EnableEvents = True
End If
End With
End If
End Sub
This is an accumulator, and it works, but I need it to also do the same thing on the same sheet but for different target and range. Just like with F3:F4 to "V",I need F6:F7 to produce a result on "W"
Any help would be great. I have mucked with it for several hours trying to get it to work.
Thanks
__________________________________________________________________
Mod edit : post moved to appropriate forum …
Last edited by a moderator: