Friends,
Please, does anybody know how to avoid looping using Target within Worksheet_Change?
Example:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then
Exit Sub
Else:
Target = Target + 1
End If
End Sub
When I type 1 in A1, for example, I want Excel to make it 2, but it keeps on looping because every time the value changes, it runs the code again and again. So, that's my point: how to make it runs only once?
Thank you very much for your attention. :)
brunces
Start Free Trial
