How to execute a line-drawing subroutine/macro?

Hi!

Thanks a lot for this. However, my computer is flagging it with some message saying that it doesn't trust the file. Just to be on the safe side, could you tell me the code you used? I hate to be so skeptical, but I also want to work on my VBA coding skills.

Also, I've been working on it myself, and I got the line drawing part to work by calling the subroutine in another macro. I want to get it to draw arrows instead of lines and take the selected cells as a range.

Please Login or Register  to view this content.

Thanks!

Thanks a lot. In the meantime, I was able to actually make a program myself, although much simpler than yours. I will take a look at your code so I can understand some of the subtleties. Anyhow, for the benefit of anyone stumbling across the thread in the future, here is my bare-bones version of the program:

Please Login or Register  to view this content.

I was actually inspired by your idea of using a range selection to identify the cells of interest.