Insert tab name into worksheet cell

Hi experts

I am trying to insert the tab name into the worksheet

And I keep on getting #Value error... Using the following formula

=REPLACE(CELL("filename",B2),1,FIND("]",CELL("filename")),"")
route217Asked:
Who is Participating?
 
Rory ArchibaldCommented:
Have you saved the file yet? If not you will get that error.
0
 
route217Author Commented:
Makes sense Rorya....

Once again thanks for the feedback
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.