Referencing sheet codename instead of sheet name not working

[jshaw82]

Hi All,

I'm trying to reference the sheetcode name in a workbook but its giving me errors:

Please Login or Register  to view this content.

is my original code but i want it to reference the codename. I changed it to:

Please Login or Register  to view this content.

which are the codenames for the respective sheets but it wont work. "wb" is defined earlier in the code as a different Workbook from a getopenfilename command.

Thanks in advance

John

[jshaw82]

The error is "method or data member not found"

[jshaw82]

Ok, seems you cant reference a codename in another book. and you dont need ThisWorkbook when referencing a codename in the book the code is running in