Tab Name or Sheet Name in a Cell

  • Thread starter Thread starter John T. Riordan
  • Start date Start date
J

John T. Riordan

I want to return the Worksheet name to a cell in each
worksheet of the workbook.

Last week I was recommended to use:

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

which works fine when used in one worksheet only, but
when used in many worksheets, they all change to the same
name.

Does anyone know of a way to return the name to a cell
using something like the properties of the workbook?

Thanks in advance,
John T. Riordan
 
John,

It's simply a question of adding a cell reference so that the formula refers
to that worksheet, not the active one, i.e.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks very much Bob,
that seems to do the trick.

John
-----Original Message-----
John,

It's simply a question of adding a cell reference so that the formula refers
to that worksheet, not the active one, i.e.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I want to return the Worksheet name to a cell in each
worksheet of the workbook.

Last week I was recommended to use:

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

which works fine when used in one worksheet only, but
when used in many worksheets, they all change to the same
name.

Does anyone know of a way to return the name to a cell
using something like the properties of the workbook?

Thanks in advance,
John T. Riordan
Click to expand...


.
Click to expand...
 
Glad to help John.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

John T. Riordan said:
Thanks very much Bob,
that seems to do the trick.

John
-----Original Message-----
John,

It's simply a question of adding a cell reference so that the formula refers
to that worksheet, not the active one, i.e.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I want to return the Worksheet name to a cell in each
worksheet of the workbook.

Last week I was recommended to use:

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

which works fine when used in one worksheet only, but
when used in many worksheets, they all change to the same
name.

Does anyone know of a way to return the name to a cell
using something like the properties of the workbook?

Thanks in advance,
John T. Riordan
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top