P
Patrick Simonds
How can I place the current worksheet name into cell A1?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
R
RagDyeR
The WB *must* be saved for this to return the sheet name.
=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
How can I place the current worksheet name into cell A1?
=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
How can I place the current worksheet name into cell A1?
B
Barb Reinhardt
Try this
=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1),1)+1,LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))
=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1),1)+1,LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))
B
Bob Phillips
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)