i-Zapp wrote:


copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".

Excellent, thanks. Seems to work a treat.

--
Terry, West Sussex, UK