Menu
I have searched the excel function documentation and general MSDN search but have been unable to find a way to return the sheet name without VBA.
Is there a way to get the sheet name in an excel formula without needing to resort to VBA?
464
Re: workbook and sheet name via formula you need to create a Name like "SheetName" and use GET. CELL(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.
1. Select a blank cell, copy and paste the formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) into the Formula Bar, and the press the Enter key. See screenshot: Now the sheet tab name is referenced in the cell.
Not very good with excel, but I found these here
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) and A1 can be any non-error cell in the sheet.
For the full path and name of the sheet, use
=CELL("filename",A1) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
