Worksheet name

[Trip Levert]

Hi all,
RE:Excel 2002
I would like to have a formula that will display the sheet
name in a cell. I have tried the following:
MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) &"
Segment". This requires a manual recalc to display the
correct sheet name or it will show the name of the last
sheet selected.

Thanks,
Trip

 

[Bob Phillips]

Trip,

Change it to

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

This has the effect of locking it into the sheet that A! is on, which is the
one that you enter the formula on.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Trip
you may add the second parameter for CELL (a reference):
try
MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) &"Segment"

Frank

 

[Arvi Laanemets]

Hi

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

 

[Trip Levert]

Thanks for the Help!