Macro Which Copies Range and Pastes to Existing Workbook

Hello all,

I am running this code from an existing workbook, and already have a code to copy the selected range from a different workbook. I want to copy this code and paste it into the sheet named "PRODUCTION" in cell H28.

The copy code I have is:

Please Login or Register  to view this content.

If I am running this from the template workbook I have, can I just use a .Paste to active workbook or would this not work since I have the Workbooks.Open in the Copy code?

Maybe:

Please Login or Register  to view this content.

On which line is the error?

Any ideas?

I don't think it is the problem but you have two error handlers?

Please Login or Register  to view this content.

Try removing one.

I realized that before, removed it but it still gives the same error.