Thank you so much Paul. I'm a bit puzzled as to why such a simple operation is not catered for already without having to resort to a macro.

Anyway your macro did the trick - thanks again.

Saved me a LOT of retyping