Forum Discussion
List of sheet names
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...
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())
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
