=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)

Once the file has been saved
--
Gary''s Student

Thanks

I'm looking for the sheetname not the workbookname, the sheetname could be
"Sheet1" or "February 2006".


cheers
Henry