Dominic thanks for that works fine the byval thing was my mistake not paying attention having tried copying and pasting and modifying so many times.
The worksheet code was something I was musing over for a while as I wasn't sure how it differentiated over one sheet from another so i assume it's the local sheet

Thanks again