Need Worksheet Code

[jacob]

I need to find out how to place the name of the current tab or active tab in
a cell How do i do this. It is easy to do in a Header of Footer but i want to
be able to do it in a cell.

Thanks!!!

 

[Chip Pearson]

Jacob,

Try the following formula

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

The file must have been saved for this to work. It won't work if
the file has never been saved.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Sloth]

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

you need to have saved the file at least once before it will work.

 

[jacob]

Thanks guys!!!!!!!!!!!!!!!!!!11

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

you need to have saved the file at least once before it will work.

I need to find out how to place the name of the current tab or active tab in
a cell How do i do this. It is easy to do in a Header of Footer but i want to
be able to do it in a cell.

Thanks!!!