use arrow in vba formula?

[samuelimtech]

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

[westconn1]

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

[Paul_Hossler]

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

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