title: Range as a Variable VBA
body: <p>I am trying to copy  values from sheet1 to sheet2. The number of rows of sheet1 varies so I need to store it in a variable. I need something like:</p>
  
  <pre><code>Worksheets("Sheet1").Range("A2:Ab").Select
  </code></pre>
  
  <p>, where "b" is a variable that stores the number of rows in Sheet1.</p>
  
  <p>Thank you.</p>