=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Any cell address like A1 will anchor the formula to the worksheet.


Gord Dibben Excel MVP

On Sun, 23 Oct 2005 18:57:13 -0500, MACRE0
wrote:


No :~( but I've discovered the root of the problem. I am basing
several lookup formulas on a truncated down version of the
cell("filename") to get the tab name. Is there better way of
referencing the tab with a formula than this?
{=MID(CELL(“filename”),FIND(“]“,CELL(“filename”))+255)}
Though the tabs of course remain static, the cell in the sheet states
the previous tab's name until recalced. Perhaps if I change this
formula, which all the lookups are based upon, a sheet refresh will no
longer be required.