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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=504524