So here is my problem. I have 2 open workbooks. I need to copy a set of cells and paste it to a sheet in another workbook. I have to be able to reference the code-name because the file name is always changing because of users needing to update it.
Also in the best case I would like to be able to have it look into only the open workbooks because more then likely their will be lots of the same codename because of identical wb from other jobs on someone computer.
So as it stands I have:
DRun.ActiveSheet.Range("A4:k7").copy
Activewb("MR").Inventory.Range("A3").paste
Always comes back with an error.
I have no idea how to get this to work. New here and going crazy.
Also in the best case I would like to be able to have it look into only the open workbooks because more then likely their will be lots of the same codename because of identical wb from other jobs on someone computer.
So as it stands I have:
DRun.ActiveSheet.Range("A4:k7").copy
Activewb("MR").Inventory.Range("A3").paste
Always comes back with an error.
I have no idea how to get this to work. New here and going crazy.
Last edited: