returns the worksheet name. Note that the final 25 argument is any number large enough to handle the longest sheet name you’ve used.
Additional Details: If you need to insert just the worksheet path in a cell, you can use =INFO(“Directory") instead of trying to parse it from the CELL function.
Gotcha: The INFO function used to be able to return several bits of information about memory available, total memory, and so on. While these arguments were accepted in Excel 2003, they were never correct. In Excel 2007, Excel will return #N/A if you use the INFO function to return available memory.