(Solved) – Using Ctrl +V to match destination formatting


Using the following Macro in my workbook and have assigned ‘Ctrl V’ as the shortcut to run the Macro. If I double click into the destination cell and Ctrl V it works fine. If i just single click to select the cell, I get runtime error “PasteSpecial method of Range class failed”. Is there a way around this?

Sub PasteWithDestinationFormatting()

 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *