Sheet Tab name

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

Hi

Does anyone know if there is a way to pick up the sheet name in a cell?

Thanks
Shona
 
=MID(CELL("filename",A1),1+FIND("]",CELL("filename",A1)),255)

Workbook needs to be saved before the above will work.
You may wish to substitute the cellreference of the calling formula instead
of A1, if there is a risk of Row 1 or Column A being deleted at some later
date.
 
Does anyone know if there is a way to pick up the sheet name in a cell?

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

File must be saved before this will work.

Rgds,
Andy
 
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

List folders to file 11
Count sheets in workbook 3
Lookup possibly? 3
problems getting this macro to work 23
Code Help for naming a worksheet tab 3
Tab sheet name 3
Help to create a macro 2
problem finding named sheet 1

Back
Top