Thread: AUTOMATICALLY NAME A FIELD WITH THE TAB NAME in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
  
Posts: 772
Default AUTOMATICALLY NAME A FIELD WITH THE TAB NAME in excel
After saving the workbook

=RIGHT(CELL("filename"),(LEN(CELL("filename"))-FIND("]",CELL("filename"))))
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jygong" wrote:

How would I have the name of the spreadsheet tab (on the bottom) to
automatically appear in a cell field on the spreadsheet?
Reply With QuoteReply With Quote