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
|