I re read you question and thought perhaps this is what you want.

Sheets("My sheet").CodeName

--
Regards,

OssieMac


"OssieMac" wrote:



ActiveSheet.CodeName


--
Regards,

OssieMac


"Karen53" wrote:

or something similarHi,

Is there a way to return the code name of a worksheet using sheets(ShName)?
--
Thanks for your help.
Karen53