=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.

"robertguy" wrote:


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


--
robertguy

44 Married two kids
------------------------------------------------------------------------
robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963
View this thread: http://www.excelforum.com/showthread...hreadid=481872