lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro
to select this range


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=551743

Hello Zygan,

If you are referring to a VBA macro, the code would be...

Sub Test()

With ActiveSheet
.Range(.Range("A1")).Select
End With

End Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=551743

Zygan wrote:
lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro
to select this range

In general in macros you should not have to select ranges. Instead just
create range objects.