Run a marco on sheet3, then sheet4....sheet99

[jonh]

Hi,

Is it possible to create a macro that runs another macro in sheet3, then moves on to sheet4 and run the same macro, sheet5 etc. etc.

This is further complicated by the fact that each tab is 'named' i.e. Summary, North, South, East, West, Sales Consultant North1, Sales Consultant North2... etc. I want the macro to run in "Sales Consultant Sheets" but not in the Sumarry Sheets i.e. North, South, East and West.

All the sales consultant sheets are adjacent to one another, but occassionally, sales consultants sheets are added (new additions) and deleted (sales person leaves the org).

Thanks in advance of any help...
Jon

 

[hsk]

Try this .....

Sub temp()
For i = 1 To Application.ActiveWorkbook.Sheets.Count
    If Application.ActiveWorkbook.Sheets.Item(i).Name <> "Sheet1" AND _
       Application.ActiveWorkbook.Sheets.Item(i).Name <> "Sheet2" AND _
       Application.ActiveWorkbook.Sheets.Item(i).Name <> "Sheet3"  Then

     Then
       Application.ActiveWorkbook.Sheets.Item(i).Activate
       Call mymacro
    End If
Next
End Sub

 

[jonh]

Many thanks for this.

Jon