title: In VBA, is it always better to use With, End With?
body: <p>For even two lines of code referencing the same object, is it always faster to write extra lines to incorporate With and End With?</p>
  
  <p>For example:  </p>
  
  <pre><code>If Target.Column &lt;&gt; 1 Or Target.Row &gt;= 100 Then Exit Sub
  </code></pre>
  
  <p>Versus:</p>
  
  <pre><code>With Target
      If .Column &lt;&gt; 1 Or .Row &gt;= 100 Then Exit Sub
  End With
  </code></pre>
  
  <p>Is this overkill?</p>
  
  <p>Is it dependent on the code itself to weigh up referencing an object twice vs. writing three separate lines? Or always faster to write three lines?  </p>
  
  <p>On the subject of speed - what is the optimal way to write this line in terms of processing speed? i.e. is the second test more quickly read as</p>
  
  <pre><code>&gt; 99
  </code></pre>
  
  <p>than</p>
  
  <pre><code>&gt;= 100
  </code></pre>
  
  <p>?</p>
  
  <p>Does it matter which order I test the row number and column number?</p>