Hello everyone, thanks for your attention.

I have a Worksheet with my own method (a Sub inside the code). I can successfully use this method from any Module, everything works fine.

But now I need to make (programmatically) another worksheet with the same method, in the same workbook. I faced a problem with that.

I tried creating a new Worksheet, and then copying the code from original Worksheet line-by-line. The sheet is created, the code is copied but! when I try to use my (copied) method on a new worksheet, it gives me an error "Method or data member not found".

If I copy the sheet as the code with one sub, stop it, and then run another sub that uses the method, it works fine. But if I copy sheet and try to use my method in one turn, it won't work. Maybe it's the compiler that can't read newly-inserted code for subs?

Thank you!