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