Hello,
Is there a formula that will return the name of the active worksheet?
Formula to retrieve ws name
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Formula to retrieve ws name
Nathan
There's no place like home.....
There's no place like home.....
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula to retrieve ws name
The following formula only works in workbooks that have been saved to disk, not in newly created workbooks that have never been saved yet:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.