Read Worksheet CodeName into a Formula?

[USNA91]

Is there any way to READ the Code Name of a worksheet (Sheet11, for example) into a formula in Excel?

I don't need to write to the Code Name or otherwise manipulate it; I just need to pull it out as a string and then yank out the numerical portion, all without VBA.

Thanks!

 

[dreid1011]

See if this helps: SHEET function - Microsoft Support

Upon testing, this returns the sheet position, not the number in the name of the sheet. Below, my sheets are ordered: Sheet1, Sheet3, Sheet2, Sheet4.

Book1
	A	B
1	1	Sheet1
2	3	Sheet2
3	2	Sheet3
4	4	Sheet4
Sheet1

Cell Formulas
Range	Formula
A1	A1	=SHEET("Sheet1")
A2	A2	=SHEET("Sheet2")
A3	A3	=SHEET("Sheet3")
A4	A4	=SHEET("Sheet4")

 

[USNA91]

Actually, that may work for me anyway. Thanks!

 

[dreid1011]

You're welcome, and happy to help.