Restrict Pasting to Keep Destination Match Formatting Programmatically

Hey guys,

I'm trying to restrict pasting to keep destination formatting however I'm running into a 1004 error. I've tried several different methods including a macro shortcut to paste using xlPastValues with a ctrl + v shortcut. I've also used the following code to no avail. Anyone know a workaround?

Please Login or Register  to view this content.

Where is your range Copy?

The range is copied from an intranet source so it is kept in clipboard. It has five columns and dynamic rows.

Figured it out by recording a macro and using the following code:

Please Login or Register  to view this content.