Inserting Worksheet name in a cell HELP!

I

ibo

I had same problem with Scott...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....

for XP and excel 2002

Ibrahim OZEN
 
Top