Automate draw arrows

I haven't worked with VBA in many years but used to be fairly good at it. If you don't use it, you lose it, as they say!
I'd like to create an automated arrow that will go through the spreadsheet starting at a specific cell and draw an arrow from column a to column c if column d is not "null". The arrow will need to go from the left mid point of the first cell to the right mid point of the cell in column c. The arrows will need to be drawn from the bottom of the spreadsheet to the top of the spreadsheet and I'd like to be able to tell the code to start looking at at a specific cell and stop looking at a specific cell. I've spent the entire day going through tutorials and looking at some code created by Ryan Wells without any luck.
I've tried to attach an image and insert an image but haven't had any luck with that so I hope I've explained it well enough for someone out there to give me some help, which will be very much appreciated!
Thanks!
Denise

Try the VBA below in the attached workbook.
Modify to suit your needs

Amend the values in columnD (replace blanks with values and values with blanks)
then
Run the VBA with {CTRL} + t

Note that the variables are declared at the top of the module
VBA names the arrows so that they can be deleted before the procedure is run again

Please Login or Register  to view this content.

Thank you so much! I don't have time to look at this today but it will be first thing on my agenda Monday! Have a wonderful weekend!

We got this to work with a little help from your code. Thanks again so much for the help!

You are welcome
If your original question is solved please go to Thread Tools at top of thread and Mark thread as solved. You can continue to ask related questions here.
How about clicking on * (to add reputation points) if anyone has helped you solve a problem

Hey there kev_,
I don't have a "solved" option under my thread tools.
can you show me a picture of what you see?
Thanks!

Nevermind, I wasn't logged in and it showed up once I logged in. Thanks again!