Retreiving TABNAME from within a spreadsheet
 

How do I retrieve the TAB name from within a spreadsheet to insert into a cell?

Workbook needs to be saved

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


Regards,

Peo Sjoblom

"Bob Harike" wrote in message
...
How do I retrieve the TAB name from within a spreadsheet to insert into a
cell?

Just right .. Thanks.

"Peo Sjoblom" wrote:

Workbook needs to be saved

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


Regards,

Peo Sjoblom

"Bob Harike" wrote in message
...
How do I retrieve the TAB name from within a spreadsheet to insert into a
cell?