change active sheet with a list

I have a vba script that runs mutiple macros on the same fields in the sheet. I have provided a quick sample. I can not figure out how to make a loop to run the program on a list of sheets that i can input.

example

it runs on sheet 1 via

Worksheets(1).Activate

I have tried for hours to make a loop so that it can run with numbers that i input in an array. I think an array is the best way , please correct me if i am wrong..

So the it would look like this


WorkSheets(N).Activate



I would have an array with sheet numbers

N = (1,2,3, etc)

Then somehow i would have a loop that would run through code and when it ends it would run the loops again on the next sheet 2 and then 3 until all numbers have been ran in the array.

I hope this makes sense. I can not figure out how to make the code


Here is my sample data. All the other code works. I just need to run it per sheet that i specify and loop through until all sheets specified are done.

To answer what you've asked for

NoS said:

To answer what you've asked for

Code:

N = Array(1, 2, 3)
For i = LBound(N) To UBound(N)
    Worksheets(N(i)).Activate
    '
    ' rest of code here
    '
Next i

Click to expand...

Wow that worked out perfect for what i needed to get done. Thank you so much NOS.