hi

use Edit Paste Special select "values" ok

-via135



Trev Wrote:
When I copy worksheet and paste it the values paste but not the
formulas.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=511287