Hi Henry:

Give it a try. On my system (WIN XP EXCEL XP) it returns the worksheet name
(tab name)

Good Luck
-- Gary's Student


"henry" wrote:


=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