List of sheet names

Copper Contributor

Hi all,


I'm trying to generate a list of all sheet names on a workbook and am applying a formula I found with Google. 

Nevertheless, I get an error message: "There is a problem with this formula. Not trying to type a formula? Etc.."

Would someone kindly assist me?


Luis Serpa 

2 Replies

@Luis Serpa 

It would have been helpful if you posted the formula...


If you use comma as decimal separator, you will need to replace the commas between the arguments of the functions with semicolons, for example change


=INDEX(SheetNames, ROW())




=INDEX(SheetNames; ROW())

@Hans Vogelaar 


Hi Hans. Thanks. I obviously tried to post the formula, but received an error message stating that my message had unwanted code. I tried without the formula and it went through.


As soon as I get on front of my computer will try your solution. 


Thank you again.