title: expand vba code to act the same for multiple rows without deleting all information in different rows based on a cell in a different rows value
body: <p>i am using this code in excel vba  and it is working fine for this row however i am wanting to apply the code to work in the same way but for all the rows in the m column based on the specific rows value and not clear contents of all the rows in the other columns based on 1 cell in the m columns value, hope this makes sense </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Not Intersect(Target, Range("M4")) Is Nothing Then
          Range("N4:T4").ClearContents        
      End If
  
  End Sub
  </code></pre>