Select a Sheet you don't know the name of yet?

[humboldtguy]

I have a macro that duplicates a hidden page, and names the duplicate sheet by cell reference. then the macro goes back and resets the forms that were used, what i would like to do is have it end selected on the newly created sheet, but i can't reference the sheet because i don't know in advance what the sheets name will be. does anyone have any idea how to select a sheet that you don't know the name of? Thanks in advance guys

[mudraker]

What you want can be done
As to the best method it will depend a lot on your existing code

Are you wanting to select the sheet before or after it has been renamed/created

Please post your code or preferably a copy of the workbook

[humboldtguy]

What you want can be done
As to the best method it will depend a lot on your existing code

Are you wanting to select the sheet before or after it has been renamed/created

Please post your code or preferably a copy of the workbook

Here is my code, the workbook has a lot of other peoples personal info in it at the moment....i can make a dummy if you need me to...but basically the last thing i want to do in this macro is select the newly created sheet so that the end user will hit the button and be taken exactly where he needs to be next, if that makes sense...thanks for the quick response

Please Login or Register  to view this content.

[mudraker]

Based on your code I beleive the easisest method is to use a variable

Added/changed code showing in Red

Your code can also be improved by as you do not always need to select cells to copy them - see more code posted after your macro

Please Login or Register  to view this content.

The following code is from the 1st part of your macro with most of the selection replaced.

Please Login or Register  to view this content.

[humboldtguy]

Mudraker, that is perfect...thank you so much, this forum is terrific, I can't thank you guys enough for all the help, my workbook does things I never imagined possible when I started it about 3 weeks ago...thanks again

Based on your code I beleive the easisest method is to use a variable

Added/changed code showing in Red

Your code can also be improved by as you do not always need to select cells to copy them - see more code posted after your macro

Please Login or Register  to view this content.

The following code is from the 1st part of your macro with most of the selection replaced.

Please Login or Register  to view this content.

[mudraker]

Thanks for the feed back

For Your Info
Whilst the following is not a forum rule it is considered bad posting to include all of a previous message as a quote when replying

If you do need to quote from previous posts then only include the section that is relevant to the message you are currently entering