Hi The_Prist,

Thank you for you help, however it does not work. The Worksheet change event is on sheet1.

Any other ideas greatly appreciated.

Kind Regards