Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Address in Range Definition??
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
definition of the range containing content | Excel Programming | |||
Range Definition in Macro ? | Excel Programming | |||
Range definition problem | Excel Programming | |||
How come this range definition is invalid? | Excel Programming | |||
Using Cells( ) for Range definition | Excel Programming |