The CELL Function is a standard function that will return information about the current operating system. See CELL is Excels help for details.
Formula | Result |
=MyName() | Workbook Path.xls |
=MyFullName() | C:\OzGrid\Learning\Workbook Path.xls |
=CELL("filename") | C:\OzGrid\Learning\[Workbook Path.xls]Sheet1 |
=sheetname(A1) | Sheet1 |
No comments:
Post a Comment