Is this possible?

[skutt]

I want to make make a macro that draws an arrow centered in the selected cells (say a1:d1 for example)


If possible = true then
can sombody help me out or atleast give me a start

Cheers

[Mikeopolo]

Have a look at

http://www.tek-tips.com/viewthread.cfm?qid=620419

for a really clear discussion of how the co-ordinates are programmed.

Regards

[skutt]

Intrresting thread, but I cant get the code to work . (an object is requierd)

Whats wrong?

[skutt]

How can I find a way to translate cells to coordinates x and y?