How to draw elbow with range except cell not empty?

[tuthvn]

Hi All,
I have a question that is quite difficult for me on vba software.
I have a lot of columns and need to connect areas but can't draw lines into the cells that are already in use.
for example attached image.
Thanks very much

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to draw elbow with range except cell not empty?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.