title: Excel Define a range based on a cell value
body: <p>Is it possible to define a range based on a value given in a cell. </p>
  
  <p>So, for example:
  My selection is A1:A5 That are five cells. is it possible to let excel determine this by setting a cell value (like B1) to 5. </p>
  
  <p>It for the purpose of easily changes a lot of ranges with one change in a cell value. So if I would change the cell value (B1) to 6. The range would automatically change to A1:A6</p>
  
  <p>Even more specific, I would like to do it reversed. </p>
  
  <p>Final example:
  Selection should be A6:A10 (this are the five cells). In B1 I have the value 5.
  If I change the value of B1 to 6. The range should change to A5:A10</p>
  
  <p>Could somebody help me???</p>