You Sir, are an absolute legend! That bit of code has SO nailed it on the sheet I tried it on.


I'll just finish putting it thru the entire workbook and if it works as I fully expect it to, then I will mark this as SOLVED.
Rep has been left.
Do you have a Paypal account that I can put a donation thru as thanks for your patience and perseverance?
Many thanks
Mike