Hi,
I've just started learning Excel VBA, and must say that I've found a lot of answers to my problems on this forum searching the web.
At the moment I've created a macro which involves copying data from one workbook to another. Once I got the macro to work, I figured I'd use it in another workbook as well. I copied the Module over to the other workbook, but when I run the macro from that workbook it executes the macro on the workbook I copied it from.
I've checked my code and I can't find any references to the workbook I copied the Module from. The closest I get is the ThisWorkbook statement.
Any ideas what's fooling me?
Cheers
I've just started learning Excel VBA, and must say that I've found a lot of answers to my problems on this forum searching the web.
At the moment I've created a macro which involves copying data from one workbook to another. Once I got the macro to work, I figured I'd use it in another workbook as well. I copied the Module over to the other workbook, but when I run the macro from that workbook it executes the macro on the workbook I copied it from.
I've checked my code and I can't find any references to the workbook I copied the Module from. The closest I get is the ThisWorkbook statement.
Any ideas what's fooling me?
Cheers