|
|
| Return
the Worksheet Name |
The following formula returns the worksheet name of the worksheet that
contains the reference A1...
=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")
Notes
- The argument "filename"
is literally the word "filename" within quotes.
- The workbook needs to
be saved, otherwise the formula returns the error #VALUE!
|
|
|
|
