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 |
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 |
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 |
Thanks all |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com