I have a spreadsheet that a cell displays part of the worksheet name
(tab).
We use a formula to keep it up to date:
="Sheet "&
MID(CELL("filename",B11),FIND("]",CELL("filename",B11))+2,
LEN(CELL("filename",B11))-FIND("]",CELL("filename",B11)))
The word ”Sheet” and a few spaces is always infront of the imported
worksheet name. For format consistence sake, I need the word “Sheet”
to always be bold font and the work sheet name to be normal or “not
bold”
Can I do this in the formula or with a macro or ???
Thanks
Robert Hatcher
--
Hammer_757
------------------------------------------------------------------------
Hammer_757's Profile:
http://www.excelforum.com/member.php...fo&userid=7413
View this thread:
http://www.excelforum.com/showthread...hreadid=399469