• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

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")),"")
0
route217
Asked:
route217
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now