List of sheet names

[Luis Serpa]

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?

Thanks

Luis Serpa 

[#2]

@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())

to

=INDEX(SheetNames; ROW())

[#3]

@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.

Luis