Dear All,
Here is the code for horizontal connector for an active cell where the connector displays at the middle of that cell. Its lenght is half of the previous cell + current cell + half of the next cell.
Dante gave me kindly those lines of code.
l = (ActiveCell.Offset(0, -1).Left +...