=cell("filename") in multiple places

[Ricky Pang]

Hello Experts,
What would be the workaround so that each tab in the workbook containing the
formula =cell("filename") would have the correct tab name including full
file name? It seems that this formula's limitation is that it can appear
only once in the workbook. Even then, it doesn't update the tab name
automatically.

I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it,
too, has the wrong tab name if this formula appears in multiple sheets.

Thanks in advance,
Ricky

 

[Paul B]

Ricky, try this,

=CELL("filename",A1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Ricky Pang]

Thanks Paul,
Great. That's exactly what I needed.

Thanks again,
Ricky

Ricky, try this,

=CELL("filename",A1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

Hello Experts,
What would be the workaround so that each tab in the workbook containing the
formula =cell("filename") would have the correct tab name including full
file name? It seems that this formula's limitation is that it can appear
only once in the workbook. Even then, it doesn't update the tab name
automatically.

I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it,
too, has the wrong tab name if this formula appears in multiple sheets.

Thanks in advance,
Ricky