title: VBA Trying to make WorkSheet_Change work on multiple sheets but not all
body: <p>I need to make a Worksheet_Change that checks for the change of values in 2 different cells in 2 different sheets. However I have more than 2 sheets and don't want to use a Workbook_Change so those other sheets are not affected.</p>
  
  <p>My Code works but only checks for the cells in one worksheet but not for the other worksheet. I need to check in both worksheets.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Not Intersect(Target, Range("M9")) Is Nothing Then
      Application.EnableEvents = False
      Application.ScreenUpdating = False
      Call Macro5
      Application.EnableEvents = True
      Application.ScreenUpdating = True
  
      End If
  
  If Not Intersect(Target, Range("I88")) Is Nothing Then
      Application.EnableEvents = False
      Application.ScreenUpdating = False
      Call Macro6
      Application.EnableEvents = True
      Application.ScreenUpdating = True
  
      End If
  
    End Sub
  </code></pre>
  
  <p>Thanks.</p>