Perfect !

To be honest I am just starting out with macro
I have been using other codes I have found online and altering them to suit my sheet. Some of this code might be pointless for what I am attempting to achieve but seems to work so ill just leave it until I am more experienced.

Thanks so much for taking the time to help me with this