Using a Formula to Get Your Active Worksheet’s Name, and Active Workbook’s Path and Name - KING OF EXCEL

Friday, January 3, 2020

Using a Formula to Get Your Active Worksheet’s Name, and Active Workbook’s Path and Name

Using a Formula to Get Your Active Worksheet’s Name, and Active Workbook’s Path and Name
Here are two formulas, one to return the active worksheet’s name, and the other to return the active workbook’s full path and name. In each case, please be sure to save the workbook at least once.
The formula that returns the active worksheet’s name is
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
The formula that returns the active worksheet’s full path and name is
=SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment