View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Need Function that returns active sheet name

Hi,

Am Sat, 3 Sep 2016 15:33:17 +0100 schrieb arcibald tuttle:

something like the ACTIVE.CELL() function but

ACTIVE.SHEET() and ACTIVE.WORKSHEET() which i guessed don't seem to
work.


try:

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


Regards
Claus B.
--
Windows10
Office 2016