Hi all,

I am trying to get the address of a range in a way that can be used
afterward even if the workbook or the sheet names change.

Now I am using the following:

range.get_Address(Type.Missing, Type.Missing,
Excel.XlReferenceStyle.xlA1, true, Type.Missing)

That will give me a string like this one: "[Book1]Sheet2!$A$1"

Retrieving the range object from that address will fail if, for
instance, I rename Sheet2 to Stocks.

Is there any way to do that?

Thanks.