Sheet name in a cell
 

Is there a way to bring the name of the worksheet into a cell on the worksheet?

Sheet name in a cell
 

Debra Dalgleish shares how:
http://contextures.com/xlfaqFun.html#SheetName



KevinR wrote:

Is there a way to bring the name of the worksheet into a cell on the worksheet?

--

Dave Peterson

Sheet name in a cell
 

Use a formula like

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

In this formula, use the word "filename" as shown. Don't substitute
the actual file name. The reference A1 can be any cell -- it doesn't
matter. The name of the sheet on which that cell resides will be
returned.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 18 Mar 2009 14:44:10 -0700, KevinR
wrote:

Is there a way to bring the name of the worksheet into a cell on the worksheet?

Sheet name in a cell
 

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


On Mar 19, 2:44*am, KevinR wrote:
Is there a way to bring the name of the worksheet into a cell on the worksheet?