Hi Duane,

Am Fri, 28 May 2021 14:21:14 -0500 schrieb dpb:

I was trying to build a formula to return the sheet name in a cell --

=REPLACE(CELL("filename"),1,FIND("]",CELL("filename")),"")

works for a given sheet, but it breaks when trying to use on more than
one sheet in a workbook as it is always trying to reference the first sheet.

Is there any way to get a numeric reference to the ordinal sheet
position in the CELL() reference position (other than using the text
sheet name expressly which defeats the whole ease of use thing for
wanting such)?

CELL needs a second argument, a reference.
Try:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)


Regards
Claus B.
--
Windows10
Microsoft 365 for business