getting back a cell adress into a range variable

A

Alberto Ast

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?
 
J

Jacob Skaria

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


'Range(myrange, yourotherrangeaddress).Select

If this post helps click Yes
 
Top