Worksheet name in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick Simonds - 17 Dec 2005 22:36 GMT

How can I place the current worksheet name into cell A1?

Reply to this Message

JE McGimpsey - 17 Dec 2005 22:45 GMT

See

http://www.mcgimpsey.com/excel/formulae/cell_function.html

> How can I place the current worksheet name into cell A1?

Reply to this Message

RagDyeR - 17 Dec 2005 22:46 GMT

The WB *must* be saved for this to return the sheet name.

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

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

How can I place the current worksheet name into cell A1?

Reply to this Message

Barb Reinhardt - 17 Dec 2005 22:51 GMT

Try this

=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1),1)+1,LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))

> How can I place the current worksheet name into cell A1?

Reply to this Message

Bob Phillips - 17 Dec 2005 23:20 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> How can I place the current worksheet name into cell A1?

Reply to this Message