=cell("filename") in multiple places

  • Thread starter Thread starter Ricky Pang
  • Start date Start date
R

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
 
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
 
Thanks Paul,
Great. That's exactly what I needed.

Thanks again,
Ricky

Paul B said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top