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)?

The workbook has to be saved for this to work.

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

HTH,
Paul

--

"OCA" wrote in message
...
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)?

Try,

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

Mike

"OCA" wrote:

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)?

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


"OCA" wrote:

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)?

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



On Wed, 13 Aug 2008 09:18:18 -0700, John C <johnc@stateofdenial wrote:

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

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


"Gord Dibben" wrote:

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



On Wed, 13 Aug 2008 09:18:18 -0700, John C <johnc@stateofdenial wrote:

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

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


"Gord Dibben" wrote:

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



On Wed, 13 Aug 2008 09:18:18 -0700, John C <johnc@stateofdenial wrote:

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

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

On Wed, 13 Aug 2008 15:26:01 -0700, John C <johnc@stateofdenial wrote:

I see what you are saying now, but that being said, my function still works. :)