can I automatically bring a tab's name into a worksheet?

C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
P

Peo Sjoblom

If the workbook has been saved you can use this

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

the reference to A1 does not mean anything in this case, you just need a
cell address as a part of this function, any will do

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top