G
Guest
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
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