|
|
| Return
the Workbook Path, Workbook Name, and Worksheet Name |
The following formula returns the workbook path, workbook name, and
worksheet
name of the workbook and worksheet that
contains the reference A1...
=CELL("filename",A1)
Notes
- The argument "filename"
is literally the word "filename" within quotes.
- The workbook needs to
be saved, otherwise the formula returns empty text ("").
|
|
|
|
