Hi all-
I am trying to write some VBA that will allow me to draw an autoshape arrow linking one cell to another using...
.AddLine([begin x], [begin y], [end x], [end y])

I have a grid of cells that covers the array B2:BI41 (40 rows X 60 columns) that is empty except for 7 cells which have a letter in them (a, b, c d, e, f, or g). These cells will move all around the grid. I currently have x and y "axes" along the top and left side of this grid, respectively, but they are not very useful-- simply 1 2 3 4 5 .... -- I can obviously not use these as x , y coordinates for a line.

What I would like is EITHER some way to dynamically obtain the x-y coordinates for a given cell OR dynamically create x and y axis values which I could in turn use in the .AddLine function above. By dynamically (this is the key here!), I mean that even if column widths/row heights are changed, I will still get accurate x-y coordinates for the center of that cell (or at least a good approximation).

So, for instance if "b" is in cell F19 and "e" is in cell AG38 and I want to draw an arrow from "b" to "e".... ?

Hope this makes sense! I am a complete caveman with VBA, by the way. Thanks a lot.

NOTE that I am NOT making a chart-- this is literally a grid of cells (basically, a map)