View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack Sheet Jack Sheet is offline
external usenet poster
 
Posts: 12
Default XL2007 and array of sheet names?

Can someone please tell me whether there will be in XL2007 a non-VBA method
of creating a named array of worksheet names in a workbook? I have used up
to now the old XL4 method of naming a range (say) "Sheets" that refers to
=GET.WORKBOOK(1+0*NOW())
but this is a bit unstable. Will that method even work in XL2007?