Hey guys,

I want to know if there is anyway you can help me with this. I am trying to run a macro that opens up Workbook A, copies the date from it, and pastes it into a worksheet in a workbook B that was already open. I can get this to work, but it seems that when we add more rows or columns to the report that it is pulling the data from (Worksheet A) it returns this Error when we run the Macro.

It seems that it is failing at:

ActiveSheet.Paste

Is there anything I can do without having to upload the workbook due to the proprietary information?

macro fail.jpg