Retreive sheet names of a workbook

[mr2bart]

Hi all,

I am stuck on one point: I want to retreive names of all the excel sheets but without macro.
In fact to get the list of sheets available with its names on a specific other sheet.

Do you have solution ? I search with sheet() or Sheets() but can't use with indirect().

Thanks!!!

 

[slinky]

I suspect that's not possible without macros.

 

[mr2bart]

sheet!! But thanks anyway!!

 

[mr2bart]

Hi All,
I found it!!! with function =CELL("filename",A1), it returns the complete info directory + filename + sheet name
After need to find text "]" and mid(cell where is cell formula,findtext"]",length of cell where is cell formula) and you got it !

 

[Trebor76]

Hi mr2bart,

You can list all the sheet names in a workbook using a named range and formula. Have a look at my post (number 11) from here.

Your formula will only put the active sheet name in the cell.

HTH

Robert

 

[mr2bart]

Thanks, same concept yes, I didn't checked before on this forum. I could have won much time
And agree once we get it, we can do list etc with other fonctions