I have two workbooks A and B.
I need to copy information from workbook A and paste these values into workbook B.
Although I can do this (and record the macro at the same time) when I attempt to run the macro I get the 1004 Paste special method of worksheet class failed error. I'm sure I'm missing something simple but not sure why it will let me do it when recording the macro but not when running it?
The code I am using is below, the debug indicates it's the ActiveSheet.Paste causing the issue. I've tried copying the entire sheet/columns/rows only but with the same result (plus an irritating merged cells issue)
Bookmarks