View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Array of all selected sheet names?

No, it would place the entry in the activesheet. VBA doesn't support
processing sheets as a group for the most part. This is one of those parts.

--
Regards,
Tom Ogilvy

"Jan Karel Pieterse" wrote in message
...
Hi JE,

One way:

Dim i As Long
With ActiveWindow.SelectedSheets
For i = 1 To .Count
Cells(i, 1).Value = .Item(i).Name
Next i
End With


Wouldn't that put the list in all selected sheets (since they are
grouped)?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com