title: VBA: How to use 'xltoright' and 'xldown' without using the selection method
body: <p>I am trying to speed up my macro by eliminating the use of the select method. Much of my code has code like this:</p>
  <pre><code>    Range(&quot;A5&quot;).Select
      Range(Selection, Selection.End(xlToRight)).Select
      Range(Selection, Selection.End(xlDown)).Select
  </code></pre>
  <p>how can I do the same thing without using select?</p>