Thanks but that does not seem to answer my question.

As I understand it, each worksheet has 2 names; a name and a codename.
If I look at the VBA explorer I can see 2 names for each worksheet
sheet1(Lucky).

Sheet1 is the Codename, and "Lucky" is the name.

I want to use the Codename in the function Indirect.

Thanks

JDB