Referencing Sheet Code name

Originally Posted by TMS

?sheet1.CodeName
Sheet1
?sheets("Sheet1").codename
Sheet1
?sheets(1).codename
Sheet1

Regards, TMS

Thanks TMS, however when i run the code and replace the Worksheets("report1442310827144") with sheet1.codename i get an error message '438' Object doesnt support this property or method.

Is there something i am doing wrong?

Cheers,
RJNC