Copy tab name to a cell or opposite

R

RG

What is the the index of the name of the tab? Who can I get the tab name
autmatic to a cell or the other way around? It will be nice to type a name
once - no mistakes and time saving when you use a lot of pages (sheets) and
refere to form the first sheet in abook.
 
J

Jacob Skaria

Try the below formula to retrive the tab name to a cell...To name the tab as
per cell you would require a VBA solution

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

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

Reference the same cell based on tab name 1
Variable to rename a tab in a worksheet via VBA 5
Excel Move or Copy Stopped Working? 0
Link Tab Name to Cell 2
Find and return name of worksheet tab for referenced cell 2
how can I make a cell content equal the tab name 'sheet1' ? 12
tab name = cell value 7
automatically change worksheet tab name 9

Top