I guess I am a bit confused as to what the lines in your macro refer to. I am not great with that aspect of Excel, so apologies for the beginner like questions! Can you provide a bit more detail please?

Thanks!