Hi Annie

With a worksheet level sheet name the syntax is:

Worksheets("Sheet1").Select

With a VBA level code names the syntas is:

Sheet1.Select

Hopes this helps.
....
Per

"Annie Whitley" skrev i meddelelsen
...
Hi everyone,

I've got a workbook in which other users may rename sheets so I want to
change all tab names to codenames in VBA modules.

I've read that I can do it using Find/Replace in the VBE but what I wanted
to know is whether I need to tell it I'm using the codename for sheets.

If I have to (or should) how would I do it?
--
Thank you
Annie