Cant name the cell similar with the tab name
Dear All Expert,
I would like to edit my cell name similar with the tab name.
I have tried the formula : =MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32)
Which do not work, the cell show me: #value!
How can i resolve this issue.
thanks you.
Hello ALVIN TAN,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks