Hello. How do I make a formula work on all tabs.
This is the formula that I have. =REPLACE(CELL("filename",R2),1,SEARCH("]",CELL("filename",R1)),"")
I shift all tabs, and copy over the formula in the first tab but it doesn't copy the formula into the other tabs.
What are you trying to do here?
It kinda looks like you want to extract the sheet name? If so, try this...
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
=MID(CELL("filename",B1),SEARCH("]",CELL("filename",B1))+1, SEARCH("]",CELL("filename",B1))-SEARCH("[",CELL("filename",B1))-1)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks