I'm using this code to run a macro whenever data is entered/removed from a cell within a range.
Now I need to do the same thing for a different cell range (E3:E52) and a different macro (FormatChart2). Do I need to make a new Private sub or can I add it into the existing code?![]()
Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("M3:M52") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then Call FormatChart End If End Sub
Bookmarks