Repeating VBA code for 80 sheets

[somayajif1]

Hi,

I have the below code, and I want to repeat it for 80 sheets. The workbook has a total of 90 sheets, but I need to skip the first 10 sheets as they are different and unrelated.

Please let me know if there is a way to do this. I have tried many different solutions I have found on the internet, but I can't seem to get them to work.

Please Login or Register  to view this content.

I know that I can put the following code at the beginning to make it select a particular sheet, but I don't know how to get it to loop between sheet numbers. All of the sheets are named completely differently, so I was thinking of selecting them using the sheet code name, but I don't want to just copy paste the code 80 times and change the sheet code name. I'm assuming there is a way to loop it and it would be a very short piece of code.

Please Login or Register  to view this content.

Where I would change the "10" to whatever sheet code is next. I don't know how to loop it so that the 10 changes to 11, then 12, and so on.

Thanks in advance!

[Norie]

Perhaps.

Please Login or Register  to view this content.

[somayajif1]

Works like a charm!

Thanks so much, and also for cleaning up my code that tiny bit. Very helpful! That little bit of code you helped me with actually taught me some little important things that I didn't realize before!

Thanks again!!