title: Using a variable in a range statement in VBA excell macro
body: <p>Ok, I'm sure this question is really basic but all my searchers turn up complicated answers and I've been messing with VBA for about a day.  I have two worksheets in an excel doc, I've created a button that I can click that invokes my macro that is just moving cells from one work sheet to another.  But I need my macro to determine what row I am on.  I'm using this:</p>
  
  <pre><code>r = ActiveCell.Row
  </code></pre>
  
  <p>to determine my row, but what would be the easiest way to use that variable in a range statement like this:</p>
  
  <pre><code>Range("A2").Select
  </code></pre>