Ah great, I didn't think to use ActiveWindow, I looked down the full
list of Worksheet/Sheet object members (at least three times) but
found nothing.

I'll have to keep ActiveWindow in mind for the future - seems to have
a lot of useful properties.

Thanks guys!

On Jun 23, 5:14*pm, Gary''s Student
wrote:
Sub which_ones()
For i = 1 To ActiveWindow.SelectedSheets.Count
* * MsgBox (ActiveWindow.SelectedSheets(i).Name)
Next
End Sub

--
Gary''s Student - gsnu200793