Starting code on specific middle sheet and every sheet after

[Xybry]

Excel macro code starting on specific middle sheet and running on every sheet after to the last sheet.

Question? - any coding suggestions for the following:

I need to run code on a sheet “Deals” (same name every month) and the same code on every sheet after “Deals” but the position of sheet “Deals” changes every month and the total number of sheet varies from 150-250 per month with new sheet names every month?

Thank you in advance!
Xybry

 

[Norie]

I suppose you could use Index, something like this perhaps.

For I = Worksheets("Deals").Index To Worksheets.Count
     Set ws = Worksheets(I)
     ' run code on ws
     MsgBox ws.Name
Next I

A better idea might be to run through all sheets and check their names, but that would only work if there was some way of distinguishing which sheets to work with using their name.

 

[Xybry]

Norie,

Thank you but, unfortunately, it does not work. It stays on the "Deals" tab and continues to loop but does not advance to the following tabs. Do you have another suggestion?

Thank you,

Xybry

 

[Norie]

How does it not advance?

What is your actual code?

 

[Xybry]

Norie,

Thank you very much for your help, you inspired me to approach the problem from a different viewpoint and came up with the simplest solution, ActiveSheet.Next.Select. Therefore, it now works. Good old Occam’s Razor, the simplest solution is usually the correct solution.

Thanks again for your help,

Xybry

 

[Norie]

Glad to see you got it working.

There is probably a 'better' solution though.

The reason I'm saying that is because there is no need to actually select a worksheet to work with it.

If you post the code that you say didn't work I might be able to demonstrate what I mean.