Short Cut Key???

[chaju]

Hi everyone,,

Any shortcut key for Paste Special (Value)
or else can I create a short cut key for it?

Many thanks

 

[Dave Hawley]

Hi

You will need to create one, this should do the trick.

Sub MakeValueOnly()
Selection=Selection.Value
End sub

 

[chaju]

ANY step to step guidance? as I am not good at macro...

 

[Dave Hawley]

Sure, Hold down the Alt key and push F11. Go to Insert>Module and then paste in the code. Hold down Alt and push Q Now again hold down the Alt key and push F8, select the macro name then click "Options" and assign a shortcut key.

 

[chaju]

Thanks but I try to copy a cell with formula and press Ctrl+.. ,, i doesn't give me the value..

I guess it only works when transforming the formula into value..

Is that any further suggestion?

 

[Dave Hawley]

Oh, in that case use this


Sub MakeValueOnly()
On Error GoTo EmptyClipB
Selection.PasteSpecial xlValues
Exit Sub
EmptyClipB:
MsgBox "Clipboard Empty"
End Sub