Tabs in worksheet

  • Thread starter Thread starter Gerry
  • Start date Start date
Gerry,

You mean the tab name in a cell?

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Array 3
Worksheet tab name 12
Problem with 2007 saved as 2003 2
Excel formula for an "if" "then" scenario linking 3 worksheets 2
Protected Worksheet Tab Order 1
Name a worksheet tab based on the value in a cell. 1
When sharing, can I force an Excel document to open in a certain view? 0
How to refer to tab names? 1

Back
Top