=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))

Of course, the file must have been saved at least once.
--
Gary''s Student - gsnu200832


"OCA" wrote:

How would I go about making a cell equal the name of the worksheet, in which
it is entered? I.e. in Sheet1, cell A1 equals 'Sheet1'? Is this possible?