Hi

I would like to display the worksheet name is a cell, is that possible
(how)?

something like =me.name

regards
Henry

Try:

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

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


"henry" wrote:

Hi

I would like to display the worksheet name is a cell, is that possible
(how)?

something like =me.name

regards
Henry

=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

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