Dim myRange as Range
Set myrange = Range(CStr(Range("A2")))


'Range(myrange, yourotherrangeaddress).Select

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

previousy I store a cell.adress into A2

So A2 shows as $R$5

now I need to pull this address store in A2 back into a range variable so I
can use it to select a larger range.
How can I do ti?