Removing Inefficent Code

[hchurch]

I have several instances of code that repeats for different variables, cells, and ranges. Being new to vba programming I need help in trying to condense and streamline the code that I am using if possible. This first code sample is repeated 5 times:

Please Login or Register  to view this content.

This second code sample is repeated 10 times:

Please Login or Register  to view this content.

I am also attaching a copy of the entire workbook. The above code is in the Sheet1, worksheet activate sub.

[Living Knecht]

Hi,

the values for different sheets and cells You can hold in an array and then go through it using a For-Next cycle. But as for the different variables... I do not know, if it is possible. What about to use an array here, too, and instead of VarA, VarB... call them aVar(1), aVar(2)...?

[snb]

First have a look into 'passing arguments"

instead of

Please Login or Register  to view this content.

you'd better use:

Please Login or Register  to view this content.

And plunge into 'loops'

Please Login or Register  to view this content.

[hchurch]

Thanks snb. That is getting closer to what I was looking for. However, your code iterates through columns 4, 10, 16, 22, 28:

Please Login or Register  to view this content.

I need to process columns 4 & 10 as a set, then the next iteration needs to process columns 5 & 11, etc. Each step uses a different set of comparison variables for the intCountMin & intCountMax variables.

[hchurch]

Thanks snb. I figured out how to get my iterations to work the way I want.

Please Login or Register  to view this content.

Appreciate the help. Now I can apply that to other procedures and greatly reduce the amount of coding in this workbook.