Thread: A fun puzzle...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
Posts: 3,872
Default A fun puzzle...

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


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.

Claus B.
Microsoft 365 for business