Display Tab name in Cell

  • Thread starter Thread starter universal
  • Start date Start date
U

universal

Hello All,

As the title says really. Im trying to display the name of eac
worksheet (tab) in a cell at the top of each worksheet.

Any ideas?

I've so far been unsuccessful using "normal" excel functions, I suspec
it is possible only through using macros. Though it would be mor
helpful if I didnt have to.

Thanks in advance,

Eddi
 
Another Way would be to use the "Right" function:

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-
FIND("]",CELL("filename",$A$1)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name a worksheet tab based on the value in a cell. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Worksheet (tab names) in cells 3
Tab Names to Match Cell Values when Changed 8
Copy a cell from a diferent tab when the tab name is in a cell 2
Linking Tab/worksheet names to a worksheet cell 3
Worksheen name referencing to create a 'back' button hyperlink 1
Macros, Tab Index & the Name Cell 1

Back
Top