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