Referencing worksheet with changing worksheet name

[undergraduate]

Hello, I am running into a problem.
I have a worksheet that has a changing name that is open initially, users change it frequently.
I run a macros that goes to a second worksheet.
I would like to go back to the previous worksheet with the changing name and copy data in it to another sheet. I was wondering how I can reference the worksheet in a macros that was initially open since the name changes

[DonkeyOte]

Use it's code name ?

see: http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm

[undergraduate]

How would I give a code name to the active sheet?

[DonkeyOte]

read the link provided - the code name is predefined.

[undergraduate]

Unfortunately, i didnt specify before, but the sheet one is initially can also change as well/ renamed. Thus i am not sure how the code name will help me. I would like to call upon whatever sheet I am initially opened in when running a macros so I can come back to it. If there is someway for me to assign a value to the initial active sheet, and call upon this later, that would be ideal

[DonkeyOte]

I can't follow what you're doing at all I'm afraid as the goalposts appear to have been moved.

If you need to store the "ActiveSheet" at run time then store as a Worksheet object

Please Login or Register  to view this content.

[undergraduate]

Thank you, and now with that in order for me to select the previous activesheet how do I do it?
Instead of Sheets("1").Select
If I do wsactive.select or sheets(wsactive).select it does not work, once i figure that out my question has been resolved. thank you.

[undergraduate]

It says just with

Please Login or Register  to view this content.

that object is required. why is that?

[romperstomper]

Because you need ActiveSheet rather than ActiveWorksheet.
To activate it again at the end use:

Please Login or Register  to view this content.

Note also that it is almost never necessary to activate or select anything in code.