03 excel - macro ref when copying a worksheet

[cesmythe]

I have a "master" worksheet that has a macro. When I copy and rename the worksheet, the macro reference does not change to the name of the copied worksheet. It retains the original "master" reference. When I run the macro from the new worksheet it runs the macro on the "master" worksheet as that is what is referenced in the macro.

So how do I copy a worksheet and have the macro reference the new worksheet name?

Thanks in advance.

Charlie

 

[Norie]

Charlie

What 'macro reference' do you mean?

Is it the name of the worksheet in the code?

 

[cesmythe]

Yes. The name of the worksheet in the code on the new worksheet.

 

[Rick Rothstein]

It would be so much easier for us to help you if you had only posted the macro's code. But you didn't, so let me take a guess. I'm guessing your macro has some lines of code containing references like either this...

Worksheets("Master")

or like this...

Sheets("Master")

If so, try replacing all of them with this...

ActiveSheet

 

[cesmythe]

That's it. So simple, thank you. I have 2 other questions which I'll post later - maybe you can help with those.

Thanks again.
Charlie