I think:

=cell("filename",a1)
will be better.

If a range reference isn't included, then the formula will evaluate to whatever
workbook/worksheet is active at the time of the last calculation.

John Bundy wrote:

Well heck, guess I could do that trim for you. This works for me
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.

"John Bundy" wrote:

You can get it using cell like so
=CELL("filename")

trim as needed
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"John" wrote:

I keep a workbook of employee training; each "tab" of the workbook has the
name of the employee. Is there any way to insert the contents of the tab
label (the employee's name) into the contents of a cell within the worksheet?

--

Dave Peterson