Tab Name

[Yippy_Kiyey]

I have a workbook with several tabs and each tab represents a project number. I want the tab name to appear on Cell A1, so that when I change the Tab Name, Cell A1 will also change.

Really need the help. Thanks a lot.

Rey

 

[Andrew Fergus]

Hi

In cell B1 enter this formula:
=CELL("filename",C1)

And in cell A1 enter this formula:
=RIGHT(B1,LEN(B1)-FIND("]",B1))

Andrew

 

[Yippy_Kiyey]

In cell B1 enter this formula:
=CELL("filename",C1)

And in cell A1 enter this formula:
=RIGHT(B1,LEN(B1)-FIND("]",B1))

Thanks for the replay, but I don't quite get it. If I type these formulas, I get "value" on A1. The formula on B1, do I have to put it as is or replace "filename" with something else. And what is in C1
.

Thank you

 

[repairman615]

Here is another way:

=MID(CELL("filename",INDIRECT("a2")),FIND("]",CELL("filename",INDIRECT("a2")))+1,255)

Place in cell A1

-Jeff

 

[Yippy_Kiyey]

Thanks Jeff, but I am getting "value" on A1.

 

[repairman615]

I am curious,

Is this a new workbook?

If so try on a saved file, or save this new WB and reopen.

Hope that does the trick as the formula works for me with 2007

Note:
the reference to cell A2 is arbitrary, the contents of that cell should not matter.

 

[Andrew Fergus]

Has the spreadsheet been saved? From memory I think the CELL function doesn't work in an unsaved spreadsheet.

Andrew

 

[Yippy_Kiyey]

Got it guys, after saving the worksheet, I got what I want. Thank you sooooooo much.