Select A Range Of Non-Contiguous Cells In A Column, Then Return The Address Of The Last Active Cell

With an excel file opened, i'm trying to:

Select a Range of Non-Contiguous Cells within a Column, then return the address of the last active cell.

Below, is what I have so far: Note the section maked:

' I can't get the next bit to work: '

To make it work, so far :(

1. Create a new Project using VS-2010.

2. By default, the form should be displayed as "Form1.vb".

3. Add a Label (No need to name or set anything).

4. Add two buttons (Again, No need to name or set anything).

5. Double click on the Form...

6. With the form code displayed, Select all, then paste the following.

'Option Strict Off
'Option Explicit On
Imports System.IO

[Code].....