Inserting Worksheet name in a cell HELP!

[Scott]

I want to insert the worksheet name into a cell (not into
the header or footer).

Some have suggested:

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

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


but I can't get these to work. Help!!

 

[Paul B]

Scott, both should work, have you saved the workbook? it has to be saved for
them to work

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Bob Phillips]

Sure you haven't got a space before the =?

--

HTH

Bob Phillips

I have tried saving the file after inserting that text. It
still reads as the text in the worksheet instead of the
worksheet name.

Any thoughts??

-----Original Message-----
Scott, both should work, have you saved the workbook? it has to be saved for
them to work

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

I want to insert the worksheet name into a cell (not into
the header or footer).

Some have suggested:

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

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


but I can't get these to work. Help!!

.

 

[ibo]

I had same problem with you...and several times tried ...now found it.

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))
+1,34)

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

On the same formula "filename" should be uppercase FILENAME....

Bye

I want to insert the worksheet name into a cell (not into
the header or footer).

Some have suggested:

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

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


but I can't get these to work. Help!!