Is there a function that returns the name of the worksheet?
Submitted by: AdministratorExcel's CELL function comes close. The following formula displays the workbook's full path along with the worksheet name:
=CELL("filename")
For example, this formula might return something like:
C:WindowsDesktop[Budget.xls]Sheet2
Returning only the sheet name requires a more complex formula:
=MID(CELL("filename"), FIND("]",CELL("filename"))+1, LEN(CELL("filename"))-FIND("]", CELL("filename")))
Submitted by: Administrator
=CELL("filename")
For example, this formula might return something like:
C:WindowsDesktop[Budget.xls]Sheet2
Returning only the sheet name requires a more complex formula:
=MID(CELL("filename"), FIND("]",CELL("filename"))+1, LEN(CELL("filename"))-FIND("]", CELL("filename")))
Submitted by: Administrator
Read Online Microsoft Excel Job Interview Questions And Answers
Top Microsoft Excel Questions
| ☺ | What are Excel Spreadsheet Number Formats? |
| ☺ | Using Excel is there a way to close all open Excel files at once instead of closing them one at a time? |
| ☺ | How do I combine different chart types into my Excel spreadsheet? |
| ☺ | In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format? |
| ☺ | How to Change the Sheet Tab Color of Excel Spreadsheets? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | MATLAB Interview Questions. |
