I am having trouble understanding the correct used of Worksheet_Change.
When used to target a specific cell, if that cell is altered, then the change is called again... and again and again.
I've simplified the code below to show what I mean.
What is the best way of tackling this problem, avoiding an endless cycle of calling?Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address Case $A$1 If (conditions) Then Range($A$1) = new value End select End sub
Bookmarks