That it!!!

It now working. Brilliant. Now I need to figure out the best place to put it. Ive got quite bit of logic to check issues in the script already. Its whether to do it on the event of column i changing, or whether to do it right at the end when the user is finalising the spreadsheet.

Ill hve a think about that. Thak you again!!!!