getting back a cell adress into a range variable

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
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?
 
Dim myRange as Range
Set myrange = Range(CStr(Range("A2")))


'Range(myrange, yourotherrangeaddress).Select

If this post helps click Yes
 
Back
Top