Cell to reference sheet tab name

G

Guest

Is this an option? I want a cell on a worksheet to reference (copy) the sheet
tab name.
Excel (Office 2003)
 
P

Peo Sjoblom

The workbook needs to be saved

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


You can put this in any cell, the formula needs a cell reference that is
what A1 does but it can be any cell


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 

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

dynamic worksheet name 1
Reference to sheet name in another workbook 3
Referencing Tab Name in Excel Spreadsheet? 5
How can I reference a cell on a previous worksheet 3
Referring to cells on other sheets using formula 3
Worksheet Tab Names 1
EXCEL - FORMULA TO CREATE A TAB REFERENCE 1
sheet 1, cell (n#) and sheet "N" tab name 1

Top