i have a strange problem. my code does things with various worksheets in this way:
worksheets("shtOne".DoStuff
worksheets("shtTwo".DoStuff
i find that whatever stuff should be done to shtTwo is being done to shtOne unless i activate shtTwo first. activating it every time i want to do stuff with it is going to be resource-intensive.
is this a bug or am i going about things in the wrong way, please?
thanks
gusset
worksheets("shtOne".DoStuff
worksheets("shtTwo".DoStuff
i find that whatever stuff should be done to shtTwo is being done to shtOne unless i activate shtTwo first. activating it every time i want to do stuff with it is going to be resource-intensive.
is this a bug or am i going about things in the wrong way, please?
thanks
gusset