VBA paste special won't work after cut

[Gylle]

Hi all

I'm using this code:

Sub PasteAsValue()
Selection.PasteSpecial Paste:=xlPasteFormulas
End Sub

to keep the formatting in worksheet.
It works as intented.

However if I for some reason need to cut (ctrl-x) in the worksheet and try to paste with ctrl-v it returns error 1004

I can use the mouse right click to paste or via excel menu, no problem, but not via shortcut?

 

[My Aswer Is This]

Show us the entire script.

 

[Alex Blakenburg]

My guess is that you assigned the short cut key ctrl+v to your macro.
I don't think that is a good idea it is far too useful and commonly used shortcut key to be reassigned and if you use that on anyone else's computer they will be really annoyed.

The VBA Paste only allows the same functions as if you were doing it manually.
If you do it manually Copy allows Paste Special but Cut does not.

That is why trying to paste formulas is erroring out

 

[Gylle]

Show us the entire script.

this is the entire script

Sub PasteAsValue()
Selection.PasteSpecial Paste:=xlPasteFormulas
End Sub