Hello, I have a formula that is
Placed in Name Manager with a title of SheetNames:
Placed in Cell A2:A31:
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
1,2,3,4, etc....
Placed in Cell B2:
so once I put the code into B2, I get "#BLOCKED!"=INDEX(SheetNames,A2)
Not sure why. The code worked for a day and now it is not.
Any help is appreciated, thank you.
Looks OK to me.
See yellow banner (top) and post a sample file. also read here:
https://support.microsoft.com/en-us/...5-aa59d37d6e7c
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
This works fine... for me.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Glenn, it must be a right thing or something else. When I click in one and then out I get #NAME? and cannot copy the formula back into that cell. Thanks anyways, I will have to figure a workaround instead of that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks