Auto insert tab name in cell

[Norm]

Is there a function to use the Tabname or sheetname in a cell?

 

[Chip Pearson]

Norm,

Use the following formula:

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

The file must have been saved for this to work.

 

[Norm]

Thx chip

Norm,

Use the following formula:

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

The file must have been saved for this to work.

Is there a function to use the Tabname or sheetname in a cell?

 

[shades]

There is a free add-in (in either English or French) call morefunc. Ver
handy product.

http://longre.free.fr/english/index.html


It includes the function

=SHEETNAME()


also

=FILENAM