title: VBA: Worksheet_Change - Target.Address vs Working with Intersect
body: <p>I am successfully running a macro that includes the following piece of code: </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Address = "$B$1" Or Target.Address = "$B$3" Then
          Call MainSub
      End If
  End Sub
  </code></pre>
  
  <p>The point of this sub is to make the macro spring into action via calling <code>MainSub</code> when Cell B1 or B3 are changed. It works. </p>
  
  <p>However, when looking for a solution on how to do this, I also came across this code:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Target.Worksheet.Range("B1")) Is Nothing Then
          Call MainSub
      End If
  End Sub
  </code></pre>
  
  <p>It works just as well with only B1. </p>
  
  <p>Now I have two questions: </p>
  
  <p>1) How would I include another cell (B3) to check in the intersect method? Using <code>or</code> didn't work for me, so  I think another if-Statement after the first one would do the trick, but is there a more elegant solution? </p>
  
  <p>2) What's the advantage of using <code>intersect</code> vs simply looking at <code>Target.Address</code>?</p>