for each sh in ActiveWindow.SelectedSheets
msgbox sh.name
Next

--
Regards,
Tom Ogilvy


"Glen Mettler" wrote in message
...
I have a workbook that contains 25 worksheets. Suppose I select sheets
12,
15, and 21
Is there a way - programmatically - to cycle thru the sheets collection
and
identify which ones have been selected?

I can count the number of sheets selected with:
SelectedSheets = ActiveWindow.SelectedSheets.Count

but I can't seem to find where I can read which ones are selected.

Glen