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

[MP]

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

Thanks.

[CLR]

=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.

[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


"MP" <[email protected]> wrote in message
news:[email protected]...
> can I automatically bring a tab's name into a worksheet?
>
> Thanks.

[MP]

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.

[MP]

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.