Tab Name or Sheet Name in a Cell

[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

 

[Shah Shailesh]

Hi,
Use This formula provided your workbook should be saved.

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

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

 

[Bob Phillips]

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)

 

[John T. Riordan]

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

.

 

[Bob Phillips]

Glad to help John.

--

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

.