Copy Paste Without formatting

[beeawwb]

Hi all.

This is probably really simple, but I'm not sure how to go about it. I
do lots of cut / copy - Pasting, and hate how Excel grabs cell borders
etc when I copy and paste via shortcuts (Ctrl C-Ctrl V). I know about
Paste Special "Values" for pasting, but it's time consuming to go to
the menu, select, choose and click enter. Is there a shortcut to paste
values only (no formatting)? If not, anybody know how to make one?
(I.e, a macro, that was called with a shortcut key).

Thanks in advance,

-Bob

 

[BrianB]

There is a standard button you can add to your toolbar. Tools/customize
....
The picture looks like a clipboard with a number 12 on it.

 

[beeawwb]

Yes, can get the button as well, but what I want to do is make whatever
I have in the clipboard paste values only, by a keyboard shortcut. I
like to use Ctrl-* shortcuts for pretty much everything.

Reiterate. Skipping the Paste->Special menu entirely, (Having to choose
"values" and click "ok") make the clipboard paste values only into the
active cell/cells, via a keyboard shortcut.

Thanks for the help,

-Bob

 

[BrianB]

Copy/paste this macro and assign to a hotkey combination.

Sub MyPasteSpecial()
Selection.PasteSpecial Paste:=xlValues
End Sub

 

[beeawwb]

Excellent. Thanks for that. I just added an error handler to it,
because if there was nothing in the clipboard, it would comlain that
the PasteSpecial method of the Range class failed (Runtime Error 1004).
So I just made an on Error goto bit.

Other than that, it's exactly what I wanted.

Thanks a lot

-Bob