Fetch the last value of a range of cells
<p>I would like to (dynamically) fetch the last value of a range. Therefore I have the following code.</p>

<pre><code>Range("C13").Select
Range(Selection, Selection.End(xlDown)).Select
x1 = Selection.End(xlDown).Select
MsgBox (x1)
</code></pre>

<p>This however gives TRUE in stead of what I am looking for (the actual value of the cell). Any thoughts on what I should do to get the value?</p>