Inserting Worksheet name in a cell HELP!

  • Thread starter Thread starter Scott
  • Start date Start date
S

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!!
 
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 **
 
Sure you haven't got a space before the =?

--

HTH

Bob Phillips

scott said:
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!!
Click to expand...


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

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

Bye



Scott said:
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!!
Click to expand...
 
Back
Top