insert active worksheet name

  • Thread starter Thread starter abby
  • Start date Start date
A

abby

i want to insert the active worksheet name into a cell
where i dont have to type it every time. i have found
the fx for to insert the entire file name & worksheet

=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT
(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH
("\",CELL("filename"),ROW(1:255)))))

but i dont want all that i just want the worksheet name,
how do i do this? your help is greatly appreciated :)

thanks-abby
 
Hi

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,36)


Arvi Laanemets
 

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

Need a function to add the sheet name to a cell. 1
using a worksheet tab name as a cell entry. 2
This function returns incorrect value sporadically 1
Inserting Worksheet name in a cell HELP! 3
Vlookup and return sheet name also 2
Inerting name of current worksheet into fuction 11
Variable Worksheet Names 4
inserting worksheet name in cell using function 2

Back
Top