sheet name in workbook

[MetteGaga]

Hi,

i have this formula which works fine, but i would like to know if i can make i better.

=RIGHT(CELL("filename";Sheet1!A1);LEN(CELL("filename";Sheet1!A1))-FIND("]";CELL("filename";Sheet1!A1)))

i want to have a list that allways shows all the sheet names in the file. so if i delete one og add one the list will still tell me witch sheet names there are in the workbook.

i hope my "probleme" make sense

thanks in adwance.

[igormigor]

I use this formula:

A2 = IFERROR(INDEX(Sheetlist,ROW()),"")

For Sheetlist, you need to define it in name manager with the formula below.

Sheetlist = REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1))," ")

[MetteGaga]

If i try to define it in name manager i get this message:
We found a probleme with this formula.

[MetteGaga]

i got it to work by chaninging the , to ; thanks

[Tony Valko]

See this...

https://www.excelforum.com/showthread.php?t=929969

In the formulas you may have to replace the commas with semi-colons.