Using worksheet names in formulas

W

WightRob

Does anyone know how I can add the name of a worksheet as part of a
formula on that worksheet so that if I copy the worksheet and change
the name, the new name appears in the formula.

eg

In cell AI on worksheet named "100"

I want the formula =IF(100>120,1,0)

So that if I copy the worksheet and rename the new sheet "101" the
formula in cell A1 reads:

=IF(101>120,1,0)


Thanks in anticipation

Rob
 
B

Bob Phillips

Rob,

Try

=IF(--(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255))>120,1,0
)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top