Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Function that returns active sheet name
something like the ACTIVE.CELL() function but
ACTIVE.SHEET() and ACTIVE.WORKSHEET() which i guessed don't seem to work. anybody? thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Function to return the active sheet name | Excel Worksheet Functions | |||
Function that returns name og curred sheet | Excel Programming |