Acquire Sheet Name In Excel, there is no direct way to get the sheet name. However, you can get a sheet name using VBA using the CELL, FIND, and MID functions: = MID(CELL(“filename”),FIND(“]”,CELL(“filename”)) + 1,31)