Hi NoSparks,

Wow!! Thank you very much!!! You were spot on and I must have pasted the code into Excel incorrectly the first time. I think it was to do with the wrapped line. The macro works flawlessly and does exactly what I need it to do. I am very grateful for your help as I would not have been able to work this out for myself. I have been messing with this for hours. I can't believe you figured it out so quickly.

Thanks again, your help was most appreciated, have a fantastic day!