Excel VBA code to only paste values after manually copying cell/range of cells

[dcsooner27]

I am having trouble creating a macro that pastes values after I have manually copied a cell/range of cells. The ultimate goal is to create a shortcut so I can select any cell, press CTRL + C to copy, and then go to any other cell and press CTRL + "macro shortcut" to paste values.
I need paste values because I do not want to copy the formatting, and I am also sometimes copying cells that are formulas. I know I can just right-click and select paste values but this would actually save me a lot of time.
I have searched everywhere and tried multiple code suggestions, but every time I get "Run-time error '1004': PasteSpecial method of Range class failed".
Any help is appreciated.

 

[dermie_72]

you could try:

Sub dcsooner27()
'for tp://www.mrexcel.com/forum/excel-questions/743181-excel-visual-basic-applications-code-only-paste-values-after-manually-copying-cell-range-cells.html
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
End Sub

then assign a shortcut key to that.
It will paste values to wherever you have selected.

if you are using excel 2010, all you need to do is right click, v to paste values.

 

[chrism216]

If you dont have a right click key, just do Shift + F10 + v.