T
Trent Tevis
how do i display a worksheet tab name in a cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mzehr
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL
("filename",A56),1))
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL
("filename",A56),1))
M
mzehr
Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL
("filename"),1))
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL
("filename"),1))
-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL.("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
F
Frank Kabel
B
Bob Phillips
Don't use this formula. For reason, see the link Frank provided.
--
HTH
RP
--
HTH
RP
mzehr said:Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL
("filename"),1))-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL.("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
M
mzehr
Thanks Bob!
Mike
Mike
-----Original Message-----
Don't use this formula. For reason, see the link Frank provided.
--
HTH
RP
mzehr said:Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename"),1))-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
.
.
M
mzehr
Hi Bob,
I tried pasting your website's formula =CELL("filename",!
$A$1) into a cell, and received the error message "the
formula you typed contains an error. . ." and it points
back to "!".
If I delete the "!", then the formula works. Am using
Excel 2000.
Any ideas on what I'm doing wrong?
Mike
I tried pasting your website's formula =CELL("filename",!
$A$1) into a cell, and received the error message "the
formula you typed contains an error. . ." and it points
back to "!".
If I delete the "!", then the formula works. Am using
Excel 2000.
Any ideas on what I'm doing wrong?
Mike
-----Original Message-----
Don't use this formula. For reason, see the link Frank provided.
--
HTH
RP
mzehr said:Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename"),1))-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
.
.
B
Bob Phillips
You cannot paste this formula into a cell, you have to create a name with
that as the RefersTo value.
--
HTH
RP
that as the RefersTo value.
--
HTH
RP
mzehr said:Hi Bob,
I tried pasting your website's formula =CELL("filename",!
$A$1) into a cell, and received the error message "the
formula you typed contains an error. . ." and it points
back to "!".
If I delete the "!", then the formula works. Am using
Excel 2000.
Any ideas on what I'm doing wrong?
Mike
-----Original Message-----
Don't use this formula. For reason, see the link Frank provided.
--
HTH
RP
mzehr said:Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename"),1))
-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND
("]",CELL
("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
.
.
M
mzehr
Bob,
Thanks as always
Mike
Thanks as always
Mike
-----Original Message-----
You cannot paste this formula into a cell, you have to create a name with
that as the RefersTo value.
--
HTH
RP
mzehr said:Hi Bob,
I tried pasting your website's formula =CELL ("filename",!
$A$1) into a cell, and received the error message "the
formula you typed contains an error. . ." and it points
back to "!".
If I delete the "!", then the formula works. Am using
Excel 2000.
Any ideas on what I'm doing wrong?
Mike
-----Original Message-----
Don't use this formula. For reason, see the link Frank provided.
--
HTH
RP
Oops, typo
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND ("]",CELL
("filename"),1))
-----Original Message-----
Hi,
Try:
=RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND
("]",CELL
("filename",A56),1))
-----Original Message-----
how do i display a worksheet tab name in a cell?
.
.
.
.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.