Can anyone tell be if it is possible using vba to draw a line between two cells.
For example if i need to link Range("A2") to Range("F4") using a ActiveSheet.Shapes.AddLine command maybe?
The cell references will change so I need it to know where the cells are and draw the line between the cells i tell it to
Many Thanks