Set up a macro
'---------------------------------------------------------
Sub PasteValues()
Selection.PasteSpecial Paste:=xlValues
End Sub
'---------------------------------------------------------
then assign a shortcut key to it
Only way I know
Gaz
--
gazornenplat
------------------------------------------------------------------------
gazornenplat's Profile:
http://www.excelforum.com/member.php...o&userid=24494
View this thread:
http://www.excelforum.com/showthread...hreadid=376668