Inserting the tab name into the Worksheet

G

Guest

Other then inserting the tab name in the header or footer is it possible to
insert it into a cell by creating a formula? Or is this just not possible?
If it is possible how do you do it.
 
W

William

Michelle

Place this formula in any cell.

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filen
ame",$A$1)))


Note: The workbook has to have a path, ie. it can't be a newly created
workbook that has not yet been saved.
--
XL2002
Regards

William

(e-mail address removed)

| Other then inserting the tab name in the header or footer is it possible
to
| insert it into a cell by creating a formula? Or is this just not
possible?
| If it is possible how do you do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Repeating formulas when inserting new row 3
Fomrulae to Hyperlink to cell in another tab with the same value/n 8
tab names are wrong when printing custom footers (using [&tab] ) 1
insert a page number into a cell? 2
Inserting a worksheet name into the worksheet 2
Tab name in a cell? 7
Reference the same cell based on tab name 1

Top