title: how to specify a range in vba using a cell value in excel
body: <p>I am very new to vba and basically only use it when amending a range value (having previously recorded the script using a macro in excel). Since I add/delete rows in excel I have to go to the vba script and manually update the range part. So if my range on the excel sheet has expanded from A2:R83 to A2.R84 heres one of the parts I update from:</p>
  
  <p><code>Range("A2:R83").Select</code></p>
  
  <p>To:</p>
  
  <p><code>Range("A2:R84").Select</code></p>
  
  <p>Is there a way I can specify a cell that vba can take the range values from? eg can I, on the excel sheet cell <strong>X1</strong> input <strong>A2</strong> and in cell <strong>Y2</strong> input <strong>R84</strong> and have the vba script reference these cells to determine the current range?</p>
  
  <p>Appreciate any help!</p>