Excel cell to reference tab name

inspirz · Feb 8, 2008

Hi,

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

Thanks

Gord Dibben · Feb 8, 2008

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

akphidelt · Feb 8, 2008

It requires vb

It's not too difficult of vb coding though.

Cortez · Feb 8, 2008

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