title: VBA Select Last Column and Last Row
body: <p>I am trying to select the bottom most right cell in my field of data. I have a 20x20 grid of data and need to find the last column that it would go down to find the last row that has data. I am having trouble using active cell function with in my second line of code. </p>
  
  <pre><code> Sub Add
  
        Range("A2").End(xlToRight).Select
        Range("A2").End(xlDown).Select
  
   End Sub
  </code></pre>