Copy Module Question

[autofire]

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

 

[wigi]

Hello

Please copy the code, then we can have a look at it.
You can use the # icon to format the code.