Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in
each woksheet, I would want to see the worksheet name for whichever worksheet
I am viewing. I do not want the name to change in the cell each time I click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.

Hi,

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

Thanks,

Simon

wdogolf wrote:
Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in
each woksheet, I would want to see the worksheet name for whichever worksheet
I am viewing. I do not want the name to change in the cell each time I click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.

--
Message posted via http://www.officekb.com

Hi there,

If you use the CELL() function, don't forget to set the reference (second
syntax). This is a *very* important part of the function. Just link it to
any cell in the current sheet you're wishing to return (the name of). If
working with multiple worksheets/workbooks, you'll save yourself a lot of
headaches down the road.

HTH

--
Regards,
Zack Barresse, aka firefytr



"wdogolf" wrote in message
...
Using a formula, is there a way to display worksheet (tab names) in a
cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1
in
each woksheet, I would want to see the worksheet name for whichever
worksheet
I am viewing. I do not want the name to change in the cell each time I
click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.

wdogolf, try this,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"wdogolf" wrote in message
...
Using a formula, is there a way to display worksheet (tab names) in a
cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1
in
each woksheet, I would want to see the worksheet name for whichever
worksheet
I am viewing. I do not want the name to change in the cell each time I
click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.