Worksheet name

  • Thread starter Thread starter Trip Levert
  • Start date Start date
T

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
 
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)
 
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
 
Back
Top