Tab name in specific cell

S

Steve

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
 
R

Ron Coderre

Try this:

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

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

XL2002, WinXP
 
S

Steve

I'm getting a #Value!

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

Ron Coderre said:
Try this:

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

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

XL2002, WinXP


Steve said:
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
Click to expand...
Click to expand...
 
B

Bob Phillips

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 said:
Try this:

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

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

XL2002, WinXP


Steve said:
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
Click to expand...
Click to expand...
 
R

Ron Coderre

Steve....

Re:
=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 said:
I'm getting a #Value!

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

Ron Coderre said:
Try this:

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

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

XL2002, WinXP


Steve said:
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
Click to expand...
Click to expand...
Click to expand...
 
R

Ron Coderre

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 said:
Steve....

Re:
=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 said:
I'm getting a #Value!

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

Ron Coderre said:
Try this:

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

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

XL2002, WinXP


:

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
Click to expand...
Click to expand...
Click to expand...
 
S

Steve

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",A4))-FIND("]",CELL("filename",A4)))

Thanks again,

Steve

Ron Coderre said:
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 said:
Steve....

Re:
=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 said:
I'm getting a #Value!

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

:

Try this:

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

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

XL2002, WinXP


:

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
Click to expand...
Click to expand...
Click to expand...
 
Top