Imagine a Workbook with Multiple Sheets For this example I am taking 6 but there could very well be 60 sheets;I would like to create an userdefined function in Excel that can return the current worksheet I could use the sheetname = ActiveSheetName But the problem with this is, it works and suddenly it starts to get different sheet name For example, instead of The SHEET function can also return the sheet number for a named range or a named Excel table See the Active Sheet Number In the SHEET function, if you omit the reference, it tells you the number of the active sheet =SHEET () In the screen shot below, the result is 5, but the 3rd sheet tab is active
Solved You Must Specify A Sheet Name Output Excel Multi Alteryx Community
