On Feb 7, 6:23*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Yes, it i possible without VBA

See Bob Phillips' site for methods.

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

Gord Dibben *MS Excel MVP
I can't explain it, but:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

TK


On Thu, 7 Feb 2008 16:05:00 -0800, inspirz
wrote:



Hi,

is it possible to have a cell auto populate with the name of the tab? *I
hope this doesn't require VB.

Thanks- Hide quoted text -

- Show quoted text -