View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Using the wotksheet name in a cell

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