Keyboard Shortcuts for Paste Special Values and Formats
You could always Ctrl+C to copy and create a record a macro for
EditPasteSpecialValues and assign it to Ctrl+Z key for example. Or cut and
past the following code
Sub pastespecialvalues()
'
' pastespecialvalues Macro
'
' Keyboard Shortcut: Ctrl+z
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub
"Scott" wrote:
Hello,
Are there keyboard shortcuts for the commands below? I use these commands
frequently so I'd like to find a way to be more efficient.
Need short-cuts for:
Paste Special -- Values
Paste Special -- Formats
Thanks,
Scott
|