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