Looping only through selected sheets

[Paul S]

What is the VBA code to loop through only the selected sheets in a workbook?
That is if I have a workbook contain sheets A, B, C, D, and E and if I have
selected multiple sheets, say A, B and E, how do I write code that will
perform operations only on those sheets (A, B, and E)?

 

[Dave Peterson]

dim sh as object 'could be a chart sheet???
for each sh in activewindow.selectedsheets
msgbox Sh.name
next sh

 

[Mike H]

Hi,

Try this

Dim sh As Object
For Each sh In ActiveWindow.SelectedSheets
MsgBox sh.Name
'do things
Next

Mike

 

[Paul S]

Hi,

Try this

Dim sh As Object
For Each sh In ActiveWindow.SelectedSheets
MsgBox sh.Name
'do things
Next

Mike

 

[Paul S]

Thanks. Did not think of using the Window object. Though it should be in
the Workbook object.

 

[Dave Peterson]

But you could have multiple windows into the same workbook. And each window
could have different sheets selected.

What would you use?

 

[Paul S]

You are right. Thank you very much for your help.