=MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024)


"Kirk P." wrote in message
...
I know I can get the file name and path in a cell with =Cell("filename"),
is
there some similar functionality for getting the sheet name in a cell?