Hi Folks,

Need some more help here.....Below is macro used to find the address of the
last cell in the last column used and store that address in variable "R"...

Sub lastcell()

Dim R As String

Cells(Rows.Count, "B").End(xlUp).Select
Selection.End(xlToRight).Select
R = Selection.Address
MsgBox (R)

End Sub

MsgBox will show the Address of the last cell. Assume last cell is H8,
Msgbox will display "$H$8".....This address is also stored in "R".

My question is how do I use the data stored in "R" in a Range
call....similar to the following...

Range("B4:R").Select

Thanks in advance,

Don