As always, another vote for the MVPs.

Thanks EagleOne (Dennis)

Bob,

This form of Hyperlink is volitile:
=HYPERLINK("#"&CELL("address",'Sheet2'!B32),"Click Me")

Above is also the starting-point formula in Cell A1 on Sheet1.

I inserted a row in Sheet2 (changing the linked Cell from B32 to B33)

Now the Formula in Cell A1 Sheet1 is:

=HYPERLINK("#"&CELL("address",'Sheet2'!B33),"Click Me")

This is exactly what I want .... except that:

When I run the Macro:

With Range("A1").Hyperlinks.Item(1)
 MsgBox Left(.SubAddress, InStr(.SubAddress, "!") - 1)
 MsgBox Right(.SubAddress, Len(.SubAddress) - _
       InStr(.SubAddress,  "!"))
End With

The macro returns:

Sheet2
B32    (Which s/b B33)

Is not the subaddress updated when a volitile formula changes?

Plan B

Do a "string" analysis of the current formula to get B33.

What are your thoughts and/or suggestions (to a better approach?)

TIA EagleOne

Bob,

This is what I came up with:

   With Range("A1")
       BeginStr = Len(Left(.Formula, InStr(.Formula, "!") + 1))
       SecondStr = InStr(BeginStr, .Formula, ")")
       CellRef = Mid(.Formula, BeginStr, SecondStr - BeginStr)
       MsgBox CellRef
   End With

That said, I would like to know why the SubAddress information was not
updated permitting your macro to return the updated SubAddress, if in
fact, it ever is updated.

TIA  EagleOne