Reference to a worksheet name in a cell on another sheet

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

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.
 
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
 
Shane Devenshire said:
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.
Click to expand...

Thanx.

Wonder why "sheetname" is not provided as an Info_type?
 
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

Howard Kaikow said:
Shane Devenshire said:
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.
Click to expand...

Thanx.

Wonder why "sheetname" is not provided as an Info_type?
Click to expand...
 
Back
Top