dim wss as worksheet
For each wss in activewindow.selectedsheets
'your code
next wss

If they've already been selected.

Dr.Schwartz wrote:

Yesterday Bob Phillips kindly supplied me with code to select multible sheets.

Now I need to run some code on each of the selected sheets - but how? This
is what I have come up with so far (but is not working):

Dim WSS As Worksheet
For Each WSS In Application.Selection
'my code
Next

Suggestions? Thanks / The Doctor

--

Dave Peterson