• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Named Range Conflict?

Tech56

Member
Hello I am trying to use this formula to get the worksheet names in cell A1:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

It works for all sheets except for the Categories sheet. There is a named range in column A which I think is conflicting with the formula.

Can someone please check this?

Thank you very much
 

Attachments

vletm

Excel Ninja
Tech56
1)
Screenshot 2019-09-09 at 22.22.32.png


2) Do next to that cell:
Format the cell as "General". (Right-click the cell, select Format Cells, and choose "General.")
Delete the "=" at the beginning of your formula, and hit Enter. Insert the "=" back in the formula at the beginning.
 

Tech56

Member
Could you please attach the file for the correct result? I cannot seem to get this to work correctly.

Thanks
 
Top