VBA for Match Destination Formatting

[wingdub]

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:

Please Login or Register  to view this content.

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!

[AliGW]

Duplicate of this thread: https://www.excelforum.com/excel-pro...ormatting.html

Do not open duplicate threads on the same issue. Thread closed.