Thread: A fun puzzle...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
Posts: 109
Default A fun puzzle...

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

--