cell equal worksheet title
 

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?

cell equal worksheet title
 

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

cell equal worksheet title
 

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?

cell equal worksheet title
 

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