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

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

Thanks.

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

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

Vaya con Dios,
Chuck, CABGx3



"MP" wrote:

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

Thanks.

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

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


"MP" wrote in message
...
can I automatically bring a tab's name into a worksheet?

Thanks.

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

Thanks. I appreciate your help!

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"MP" wrote:

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

Thanks.

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

Thanks. I appreciate your help!

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"MP" wrote:

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

Thanks.