How Do I insert the Worksheet Name in Cell A1 ?

R

robertguy

Hi,

can anyone tell me how do I insert the Worksheet Name in Cell A1 ?

Excel version 2000


Many thanks in advance for any help


Rob
 
S

Sloth

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

Insert this formula exactly. Just copy and paste this formula, and don't
change a thing. Most people are tempted to insert the filename where it says
"filename" but leave it exactly like it is.
 
J

Jane

in cell A1 type =cell("filename") - don't put the actual filename in and do
include the "s.
 
S

Sloth

Oh and FYI this only works if you've saved the file at least once.

Sloth said:
=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

Insert this formula exactly. Just copy and paste this formula, and don't
change a thing. Most people are tempted to insert the filename where it says
"filename" but leave it exactly like it is.
Click to expand...
 
Top