View Single Post
  #1   Report Post  
johnT
 
Posts: n/a
Default Extracting worksheet names....

Hello,

I use the following formula to display worksheet names in
a cell:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Is there a way to list the names of all the worksheets in
the entire workbook on one sheet?

(thanks)