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?

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

this one

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31)

"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?

This will return the name of the active sheet in the active workbook when excel
recalculated.

If you want the name of the worksheet that contains the formula, you'll want to
include a cell reference like Gary's Student suggested.

muddan madhu wrote:

this one

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31)

"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?

--

Dave Peterson