bug

Your formula returns the entire path,filename and sheetname.

OP wanted the sheetname only.

Also note what happens using your formula when you switch sheets then come
back to the original sheet.

Visit Bob's site for more info.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 16:59:03 -0800, "lightninbug"
wrote:



Hello All,
Maybe I am missing something here but I am required to do this on all my
work on the job. Select the cell where you want the file name to appear then
type the formula -
=CELL("filename")
then hit enter.
Like I said maybe I missed a bit if information, wherein this longer more
complicated formula must be used.