Creating a collection of sheets in Excel

[Lippershey]

Hi

Does anybody know if it is possible to create a collection of several selected worksheets in VBA for Excel, so that a loop can be created to perform a procedure for each member (ie sheet) in the collection. I hope that makes sense!

Cheers,
Paul.

 

[ilses]

If you want to loop through sheets that have been selected:

Sub Test()
Dim sh As Worksheet
For Each sh In Workbooks("WKBookName.xls&quot.Windows(1).SelectedSheets
MsgBox sh.Name
Next sh
End Sub

IS