excelledsoftware, thank you very much for your time and expertise.
I have ran the final VBA code you posted and it works like a dream!
I have also been going down through the code and re-writing it into VBA to familiarize myself with it and gain an understanding of writing the code.
However, I have tried to run the first macro: GetTheLineColors but with no end result. I must be missing a step in the process; I definitely have the code correct, definitely ran the macro and I have enabled the macro security settings. I don't see any result to 'paste into Excell'.
Any further help you can offer is greatly appreciated.