#### abberyfarm

##### Well-known Member

- Joined
- Aug 14, 2011

- Messages
- 733

I have four variables a1, a2, cr and s in the macro below.

Code:

```
Public Const cr As Long = 4
Sub Mode5()
'4 are the constants you can vary to test different scenarios
Const a1 As Single = 0.1
Const a2 As Single = 0.4
Const s As Single = 3
```

It is easier if think of these variables in this format (a1, b1, cr, s).

So taking the code above as an example they can be written as (0.1, 0.4, 4, 3).

Ultimately I would like to try different combinations of these values to get a desired outcome. Currently I change the values manually each time.

Variable a can range from 0.1 - 2.5 (25 numbers)

Variable b can range from 0.1 - 2.5 (25 numbers)

Variable s can range from 1 - 10 (10 numbers)

Variable s can range from 1 -10 (10 numbers)

I would be grateful if somebody could help me write some code to iterate through different combinations of these variables. I presume it would be some sort of loop which increments each variable a certain amount each time until the max value is reached.

For example the first combination would be (0.1, 0.1, 1, 0.1) and the next would be (0.2, 0.1, 1, 0.1) and the next (0.3, 0.1, 1, 0.1) etc and the last one would be (2.5, 2.5, 10, 10).

Altogether there can be 25 x 25 x 10 x 10 = 62,500 combinations.

I hope I have explained this well enough for you to understand, if not please don't hesitate in asking questions.

Thank you for the help.