Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
tab name
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 |
#2
|
|||
|
|||
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 "nospam" wrote in message ... 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 |
#3
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH RP (remove nothere from the email address if mailing direct) "nospam" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|