Cell Formula

[Guest]

I got few worksheets in a workbook. Each worksheet has it name. I try to
write a formula to extra the worksheet name into a cell. The formula is "
=RIGHT(CELL("filename"),4) " . It works, however, if I change worksheet from
one to another one. This formula doesn't change (calculate) itself. I have
to re-calcuate by press "F9", sometime I forgot to re-calculate before I
prite out the report. It got the wrong worksheet name. Can anyone help me
to improve my formula and make it works automatically. Thank you very much.

 

[chillihawk]

If you add the second argument to the CELL function you should achieve
your aim. For example: enter the formula in cell A1 of each sheet like
this =RIGHT(CELL("filename", A1),4).

If you don't enter the second argument you will only get information
for the last cell that was changed, not for the specific cell you are
interested in.

HTH