Selecting dynamic range
<p>Is it possible to have excel dynamic select cells? 
I'd love to know how to make a macro that does that. 
I want it to select certain cells based on the value of other cells.  For example,  ik want to select A1 to A20. And ik want to do that by simply typing 1 in a cell and 20 in another. </p>

<p>I tried this code in vba</p>

<p>Dim example as range 
Set example = range ("A1:A20") </p>

<p>Example. Select. </p>

<p>It works,  but i want the A1 and A20 to be changeable so i can select different ranges </p>

<p>Is that possible?  And if not,  what is the closest thing to it? Many thanks! </p>