cell entry equal worksheet title

[OCA]

Is it possible to make a cell entry automatically equate to the name of a
worksheet (as displayed in the tab at the bottom of the screen)?

 

[PCLIVE]

The workbook has to be saved for this to work.

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

HTH,
Paul

 

[Mike H]

Try,

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

Mike

 

[John C]

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

 

[Gord Dibben]

John

You must include a cell reference.

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

See Bob Phillips' site for explanation.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

 

[John C]

Um, actually, no, I don't. My formula works absolutely fine. Perhaps you
should test something before declaring it is incorrect?
--
John C

John

You must include a cell reference.

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

See Bob Phillips' site for explanation.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

 

[John C]

I see what you are saying now, but that being said, my function still works.
--
John C

John

You must include a cell reference.

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

See Bob Phillips' site for explanation.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

 

[Gord Dibben]

Enter your formula on Sheet1.........returns Sheet1

Enter your formula on Sheet2............returns Sheet2

Switch back to Sheet1.

See anything amiss?

I would not say "it works"


Gord