Reference to a worksheet name in a cell on another sheet

[Howard Kaikow]

Is there a way to use a built-in worksheet function, or defined name, to
refer to a worksheet name?

I'd like to fill a cell with the name of a worksheet, yet have the value in
that cell
automatically change if the worksheet name changes.

 

[Shane Devenshire]

Hi Howard,

Try something like this:

=MID(CELL("filename",Sheet2!C11),FIND("]",CELL("filename",Sheet2!C11))+1,100)

Where Sheet2!C11 is any cell reference on the sheet whose name you want.
For the active sheet, the one with the formula you can leave out the
Sheet2!C11.

Cheers,
Shane Devenshire
Microsoft Excel VBA

 

[Howard Kaikow]

Hi Howard,

Try something like this:

=MID(CELL("filename",Sheet2!C11),FIND("]",CELL("filename",Sheet2!C11))+1,100
)

Where Sheet2!C11 is any cell reference on the sheet whose name you want.
For the active sheet, the one with the formula you can leave out the
Sheet2!C11.

Thanx.

Wonder why "sheetname" is not provided as an Info_type?

 

[Shane Devenshire]

Hi Howard,

I've suggested that to Microsoft in the past but nothing has come of it.
"Book", "Path" and "Drive" might also be nice. And there are others.

Cheers,
Shane

Hi Howard,

Try something like this:

=MID(CELL("filename",Sheet2!C11),FIND("]",CELL("filename",Sheet2!C11))+1,100
)

Where Sheet2!C11 is any cell reference on the sheet whose name you want.
For the active sheet, the one with the formula you can leave out the
Sheet2!C11.

Thanx.

Wonder why "sheetname" is not provided as an Info_type?