Thread: Function that returns name og curred sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Function that returns name og curred sheet
Hi
To get the current worksheet name try:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Frank Kabel
Frankfurt, Germany

hans wrote:
Does anyone know hot to make a function that returns the name of the
curred sheet as a string

I would like to have something like

="You are on sheet" & sheetname()

Greetings Hans
Reply With QuoteReply With Quote