Sheet Reference

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a formula for listing the current Sheet. I know
about the filename cell("filename",A1) which returns the
entire path, but I just want the Sheet name to appear.
 
John,

You still use the CELL("filename") function, but you need to
trim the result a bit. Like this:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)
 
Before David McRitchie yells <vbg>, you may want to use this:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

Without the cell reference, the formula will return sheet name that was active
when xl last calculated.

(And the workbook must be saved at least once.)

Ture said:
John,

You still use the CELL("filename") function, but you need to
trim the result a bit. Like this:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden
John said:
Is there a formula for listing the current Sheet. I know
about the filename cell("filename",A1) which returns the
entire path, but I just want the Sheet name to appear.
Click to expand...
Click to expand...
 
Thanks Dave, there's always something new to learn...

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden


Dave Peterson said:
Before David McRitchie yells <vbg>, you may want to use this:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

Without the cell reference, the formula will return sheet name that was active
when xl last calculated.

(And the workbook must be saved at least once.)

Ture said:
John,

You still use the CELL("filename") function, but you need to
trim the result a bit. Like this:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden
John said:
Is there a formula for listing the current Sheet. I know
about the filename cell("filename",A1) which returns the
entire path, but I just want the Sheet name to appear.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top