Tab name in specific cell
 

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

See http://xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ron Coderre" wrote in message
...
Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab
name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

Steve....


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

You can just copy the formula directly from the post and paste it into the
formula bar.

"filename" is not the name of your file.
It's the Info_Type to be returned by the CELL function.
(I should have been more clear.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

If you put my posted formula in more than one sheet.....
all formulas will return the same value on all sheets (unless you recalculate)

To force them to show the correct sheet names,
try this, instead
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW())

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Steve....


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

You can just copy the formula directly from the post and paste it into the
formula bar.

"filename" is not the name of your file.
It's the Info_Type to be returned by the CELL function.
(I should have been more clear.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve

Tab name in specific cell
 

Ok, great. Thanks. I thought filename was the name of the file. Also, before
I saw this recalc post, I found some help here at work, and this formula also
works

=MID(CELL("filename",A4),FIND("]",CELL("filename",A4))+1,LEN(CELL("filename",A 4))-FIND("]",CELL("filename",A4)))

Thanks again,

Steve

"Ron Coderre" wrote:

If you put my posted formula in more than one sheet.....
all formulas will return the same value on all sheets (unless you recalculate)

To force them to show the correct sheet names,
try this, instead
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW())

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Steve....


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

You can just copy the formula directly from the post and paste it into the
formula bar.

"filename" is not the name of your file.
It's the Info_Type to be returned by the CELL function.
(I should have been more clear.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve