tab name

[Guest]

Hi,

RE Excel 2002 (version 10) sp3

is it possible to have a cell value displayed on the sheet tab or have
the sheet tab displayed in a cell?

Thanks

 

[Paul B]

The first one you will need a macro, a line of code something like this

activesheet.name =[a1]

for the second one this formula should work, the file must be saved first

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks all