Excel cell to reference tab name
 

Hi,

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

Thanks

Excel cell to reference tab name
 

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

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

Excel cell to reference tab name
 

It requires vb

It's not too difficult of vb coding though.

"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

Excel cell to reference tab name
 

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 -