HI,

Sorry I have not responded. But, did you create the code? If so you may be able to look at the code I posted and make the necessary correction for your file.

Hi Charles

Sorry I am very new to code.

I have pasted the code in that you sent me, as requested,But the spreadsheet only color codes as per the sheet I attached.

The workbook as a whole has a lot of code that I have had written through freelancers with some very complicated formulas that are a bit beyond my ability in excel.

But I am slowly working through the issues and learning more and more all the time.

Any further help would be very much appreciated.

Cheers
David