Dynamically change sheet name

Hi Guys!

The code I have written below is supposed to activate/select a worksheet that is standing in the range AC28 (as it should be dynamic). In this case AC28 refers to the sheet name 7.
When I try to change the sheetname of sheet '7' to the value of N1 it does not work.

Please Login or Register  to view this content.

Can anyone help me out how to change the sheetname from to the value of N1?

(At the moment even the selecting/activating of the sheet does not work, and it has to be dynamic)

Thank you guys so much!

Good afternoon Jstns

bakerman2's solution didn't work for me. Try this :

Please Login or Register  to view this content.

HTH

DominicB

Maybe:

Please Login or Register  to view this content.

All of the solutions worked!! Thank you guys for your quick replies and commitment to this forum!

You're welcome. Glad to help out and thanks for the feedback and the reps.