=cell("filename") in multiple places
 

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

=cell("filename") in multiple places
 

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" wrote in message
...
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

=cell("filename") in multiple places
 

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

Thanks again,
Ricky

"Paul B" wrote in message
...
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" wrote in message
...
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