Re workbook and sheet name via formula you need to create a Name like "SheetName" and use GETCELL (32,A1) in the Refers To area Whenever you need the sheet name you need to type "=SheetName" in the cell and you will get workbook and sheet name This is a Excel 4 Macro and not being supported Just select the name of interest in the Excel Name Manager, and type a new reference directly in the Refers to box, or click the button at the right and select the desired range on the sheet After you click the Close button, Excel will ask if1) Put every group on its own page, and 2) name each page using the same field
Return Sheet Name Into A Cell Excel Formula Youtube