Use:

=CELL("filename",A1)

will give the full path. If you need just the file name, then use:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

Mangesh



"JaneC" wrote in message
...
Hi, Is there a formula I can put in a cell that will show the name of the
sheet it is on? Thanks, Jane