Thread: can a cell be automatically populated with the workbook name?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default can a cell be automatically populated with the workbook name?
Try this,

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

Mike

"crawdood" wrote:

I have a workbook with more than 50 worksheets; iwould like a cell in each
worksheet to automatically dispaly the tab name of that worksheet - is this
possible?
Reply With QuoteReply With Quote