VBA for Match Destination Formatting

I was told the following Macro will allow me to pre-format any column, row, or worksheet to only use Match Destination Formatting when I copy data into my worksheet:

Sub PasteWithDestinationFormatting()
ActiveCell.PasteSpecial (xlPasteValues)
End Sub

I was also told I could use any shortcut (Ctrl+v, Ctrl+b, etc.).

However, none of them work; nothing appears. When I try to "Run" the code is says "run-time error 1004: pastespecial method of range class failed." What am I doing wrong?

I'm specifically looking to change the preset formatting to Match Destination Formatting for all data copied into it. I would like to use the Ctrl+v shortcut if possible but I'm okay with using another shortcut if needed. Thank you!