Leith,

Thank you for this, I cant believe how simple that was.

How do I now limit this to columns B:AR

Also is it possible to have a 'Y' entered if the formating of the above colums changes?

Once again hope you can assist