Gregory

Thanks a lot I will try it. Do I put it into my code before or after I have pasted the contents of the clipboard into the worksheet?

Thanks

Colin