mmoore5553
New member
- Joined
- Mar 8, 2019
- Messages
- 19
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365 excel
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.
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.
Attachments
Last edited: