title: I need to repeat a VBA code for rows 5-200 and have no idea how what to do
body: <p>I need to repeat a VBA code for rows 5-200 and have no idea how to do it.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Target.Address = "$L$5" Then
         Range("M5:N5").Value = "Please Select..."
  
      ElseIf Target.Address = "$M$5" Then
         Range("N5").Value = "Please Select..."
  
     End If
  
  End Sub
  </code></pre>
  
  <hr>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range) 
      If Target.Address = "$L$5" Then 
          Range("M5:N5").Value = "Please Select..." 
      ElseIf Target.Address = "$M$5" Then 
          Range("N5").Value = "Please Select..." 
      For i = 1 To 10 
          Total = Total + iArray(i) 
      Next i 
  End If
  
  End Sub
  </code></pre>