Forum Discussion

Luis Serpa's avatar
Luis Serpa
Copper Contributor
May 21, 2023

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. Not trying to type a formula? Etc.."

Would someone kindly assist me?

Thanks

Luis Serpa 

Formulas and Functions

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 21, 2023

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

    • Luis Serpa's avatar
      Luis Serpa
      Copper Contributor
      May 21, 2023

      HansVogelaar 

       

      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

       

Resources