As outlined in an earlier post you have to have the sheet in the workbook and this will work:
MsgBox ActiveSheet.CodeName 'gets the code of the current sheet but that's not what you want you need to select the sheet by its internal application name the name next to the sheet in the code view...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.