MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Filename on Workbook


Posted by Jeff on February 12, 2002 12:15 PM

When using the function =cell("filename")
The filename including the full path and worksheet name will appear on the worksheet. However if multiple worksheets are open, the worksheet name will change to whatever the active worksheet is. Does anyone know how each worksheet can have the correct worksheet name at the end of the filename?

Thanks


Posted by Juan Pablo G. on February 12, 2002 1:00 PM

Use instead

=CELL("Filename",A1)

and put this formula in each sheet. That way, each formula will refer to its own sheet.

Juan Pablo G.