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


--
i-Zapp
------------------------------------------------------------------------
i-Zapp's Profile: http://www.excelforum.com/member.php...fo&userid=5768
View this thread: http://www.excelforum.com/showthread...hreadid=479222