Excel VBA code to select non empty cells
<p>In Excel, let's I have data in B2 to B7 and C2 to C7 . In VBA I can write a macro to select it:  </p>

<pre><code>Sub Macro1()
Range("B2:C7").Select
End Sub
</code></pre>

<p>How do I rewrite the code so that it chooses automatically the cells that are non-empty?
If I delete the data in cell B7 and C7 then I want the macro to select only     Range(B2:C6)
And if I add data to Cell B8 and C8 then I want the macro to choose Range(B2:C8).</p>

<p>My data will always start a B2,C2 and I will not have any free space between data.</p>