Hi
Got a little probleme here
I want my command button on "sheet1" to copy things from "sheet2" and paste it again in "sheet1". Excel only wants to do this when i put the code in "ThisWorkbook", because if i put the code in sheet1 it doesnt seem to know sheet2. But when i put my code in "ThisWorkbook" the command button looks for its code in sheet1, not in "thisWorkbook", where i just put it.
How can i tell tho command button to look for its code in "thisWorkbook" ?
hope You can help me out.
Greetings
Bookmarks