Here's code that demonstrates how to do this.
Public Sub DoSelect()
Dim c1 As String, c2 As String
c1 = .Cells(1, 1)
c2 = .Cells(2, 1)
.Range(c1 & ":" & c2).Select
It takes the value in cell A1 and the value in cell B1 and selects the range described by those two values. If you type
"C1" in cell A1 and "D8" in cell B1 and then run this routine, the range "C1:D8" will be selected. You should be able to easilyt modify this to read the cell addresses from your own data structure rather than from cells on the worksheet.