Get Range Address from a String

[Steph]

I've loaded a cell address into a string via the following macro:

Sub Test()

Dim Rng As String

Rng = ActiveCell.Address(external:=True)
Debug.Print Rng

End Sub

Is there a way to convert the string back to full cell address (workbook,
worksheet, and cell address) without parsing the string?

Thanks for your help.

 

[Jacob Skaria]

If you mean convert back to a range..then

Dim myRange as Range
Set myRange = Range(Rng)

If this post helps click Yes

 

[Jacob Skaria]

Or do you mean,...

Sub Test()
Dim Rng As String
Rng = ActiveCell.Address(external:=True)
Debug.Print Rng

'convert it back
Dim myRange As Range
Set myRange = Range(Rng)
Debug.Print myRange.Address(external:=True)
End Sub

If this post helps click Yes