+ Reply to Thread
Results 1 to 5 of 5

Index Sheet Names formula not working

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    shelton, wa
    MS-Off Ver
    Office 365
    Posts
    24

    Index Sheet Names formula not working

    Hello, I have a formula that is

    Placed in Name Manager with a title of SheetNames:
    Please Login or Register  to view this content.
    Placed in Cell A2:A31:
    1,2,3,4, etc....

    Placed in Cell B2:
    Please Login or Register  to view this content.
    so once I put the code into B2, I get "#BLOCKED!"

    Not sure why. The code worked for a day and now it is not.

    Any help is appreciated, thank you.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Index Sheet Names formula not working

    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Index Sheet Names formula not working

    This works fine... for me.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,000

    Re: Index Sheet Names formula not working

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    11-05-2012
    Location
    shelton, wa
    MS-Off Ver
    Office 365
    Posts
    24

    Re: Index Sheet Names formula not working

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Make a index of sheet names on all workbooks
    By MattLogue9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2020, 05:20 PM
  2. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  3. Copy tabs names to index sheet in alphabetical order
    By cjharley1450 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 01:00 PM
  4. Defined Names Not Working on Specific Sheet
    By realvirtuality1 in forum Excel General
    Replies: 3
    Last Post: 03-04-2015, 12:12 PM
  5. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  6. [SOLVED] Index My Workbook - Return Sheet Names
    By JungleJme in forum Excel General
    Replies: 5
    Last Post: 12-19-2012, 07:34 AM
  7. Vlookup with index match but on sheet names
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 02-01-2012, 06:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1