use arrow in vba formula?

Hi all,

First of all let me say im pretty sure this is impossible but lets see if anyone comes up with a plan.
basically i have arrows pointing at cartain cell values, is it possible to get ascertain that cell reference through vba? the idea being if i move the arrow the refernce will change with it.

thanks for any help

please explain further, or better, post a sample workbook that demonstrates

I'm not sure yet how to determine which end has the arrow head, but you can find the cells under the ends at least

Code:

---

Sub test()
    Dim shpLine As Shape
    Set shpLine = ActiveSheet.Shapes(1)
   
    MsgBox shpLine.TopLeftCell.Address
    MsgBox shpLine.BottomRightCell.Address
End Sub

---