Gregg Wolin
Member
I know that the ability to "undo" is purged after excel runs macros. What I don't understand is if my macros are being triggered by value changes to a specific range, [i.e. Sub Worksheet_Change(ByVal Target As Range) ]why is the undo cache being purged when i change things outside of the trigger range?