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.

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

[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" <MP@discussions.microsoft.com> wrote in message
news:7770AC57-A1F1-455C-BC36-E669EF343F5F@microsoft.com...
> can I automatically bring a tab's name into a worksheet?
>
> Thanks.