Sorry I missed that there was code included.
Perhaps this page at Ron's site
http://www.rondebruin.nl/mail/folder1/mail4.htm
which has paste and saveas values
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ceemo" wrote in ...
thanx for your reply but im not really looking for the shortcuts im
looking for the code to be adjusted to auto paste the value's for me
rather than the formula's.

There must be someone on here with the expertise to help me perform
this action?