-
Sleeper: Tricky For Loop Code
Hello World!
Been working on this one a while a can't quite seem to crack it- close though! I need some VBA code that produces the data below- which is just a sample. So the LS and PB data inputs on the right are the parameters (6 inputs in total.) And the results are basically all combinations of the different parameters. Note that LS2 must always be greater than LS1, and so on. I've written some nested For Loops that are getting me 80% there but I'm still off... Thanks for any help I can get. Good luck!
LS1 |
PB1 |
LS2 |
PB2 |
LS3 |
PB3 |
|
|
10 |
5 |
|
|
|
|
LS |
INPUTS |
10 |
10 |
|
|
|
|
Start # |
10 |
10 |
15 |
|
|
|
|
Range |
30 |
10 |
20 |
|
|
|
|
Interval |
10 |
20 |
5 |
|
|
|
|
|
|
20 |
10 |
|
|
|
|
PB |
|
20 |
15 |
|
|
|
|
Start |
5 |
20 |
20 |
|
|
|
|
Range |
20 |
30 |
5 |
|
|
|
|
Interval |
5 |
30 |
10 |
|
|
|
|
|
|
30 |
15 |
|
|
|
|
|
|
30 |
20 |
|
|
|
|
|
|
10 |
5 |
20 |
5 |
|
|
|
|
10 |
5 |
20 |
10 |
|
|
|
|
10 |
5 |
20 |
15 |
|
|
|
|
10 |
5 |
20 |
20 |
|
|
|
|
10 |
10 |
20 |
5 |
|
|
|
|
10 |
10 |
20 |
10 |
|
|
|
|
10 |
10 |
20 |
15 |
|
|
|
|
10 |
10 |
20 |
20 |
|
|
|
|
10 |
15 |
20 |
5 |
|
|
|
|
10 |
15 |
20 |
10 |
|
|
|
|
10 |
15 |
20 |
15 |
|
|
|
|
10 |
15 |
20 |
20 |
|
|
|
|
10 |
20 |
20 |
5 |
|
|
|
|
10 |
20 |
20 |
10 |
|
|
|
|
10 |
20 |
20 |
15 |
|
|
|
|
10 |
20 |
20 |
20 |
|
|
|
|
10 |
5 |
30 |
5 |
|
|
|
|
10 |
5 |
30 |
10 |
|
|
|
|
10 |
5 |
30 |
15 |
|
|
|
|
10 |
5 |
30 |
20 |
|
|
|
|
10 |
10 |
30 |
5 |
|
|
|
|
10 |
10 |
30 |
10 |
|
|
|
|
10 |
10 |
30 |
15 |
|
|
|
|
10 |
10 |
30 |
20 |
|
|
|
|
10 |
15 |
30 |
5 |
|
|
|
|
10 |
15 |
30 |
10 |
|
|
|
|
10 |
15 |
30 |
15 |
|
|
|
|
10 |
15 |
30 |
20 |
|
|
|
|
10 |
20 |
30 |
5 |
|
|
|
|
10 |
20 |
30 |
10 |
|
|
|
|
10 |
20 |
30 |
15 |
|
|
|
|
10 |
20 |
30 |
20 |
|
|
|
|
20 |
5 |
30 |
5 |
|
|
|
|
20 |
5 |
30 |
10 |
|
|
|
|
20 |
5 |
30 |
15 |
|
|
|
|
20 |
5 |
30 |
20 |
|
|
|
|
20 |
10 |
30 |
5 |
|
|
|
|
20 |
10 |
30 |
10 |
|
|
|
|
20 |
10 |
30 |
15 |
|
|
|
|
20 |
10 |
30 |
20 |
|
|
|
|
20 |
15 |
30 |
5 |
|
|
|
|
20 |
15 |
30 |
10 |
|
|
|
|
20 |
15 |
30 |
15 |
|
|
|
|
20 |
15 |
30 |
20 |
|
|
|
|
20 |
20 |
30 |
5 |
|
|
|
|
20 |
20 |
30 |
10 |
|
|
|
|
20 |
20 |
30 |
15 |
|
|
|
|
20 |
20 |
30 |
20 |
|
|
|
|
10 |
5 |
20 |
5 |
30 |
5 |
|
|
10 |
5 |
20 |
5 |
30 |
10 |
|
|
10 |
5 |
20 |
5 |
30 |
15 |
|
|
10 |
5 |
20 |
5 |
30 |
20 |
|
|
10 |
5 |
20 |
10 |
30 |
5 |
|
|
10 |
5 |
20 |
10 |
30 |
10 |
|
|
10 |
5 |
20 |
10 |
30 |
15 |
|
|
10 |
5 |
20 |
10 |
30 |
20 |
|
|
10 |
5 |
20 |
15 |
30 |
5 |
|
|
10 |
5 |
20 |
15 |
30 |
10 |
|
|
10 |
5 |
20 |
15 |
30 |
15 |
|
|
10 |
5 |
20 |
15 |
30 |
20 |
|
|
10 |
5 |
20 |
20 |
30 |
5 |
|
|
10 |
5 |
20 |
20 |
30 |
10 |
|
|
10 |
5 |
20 |
20 |
30 |
15 |
|
|
10 |
5 |
20 |
20 |
30 |
20 |
|
|
10 |
10 |
20 |
5 |
30 |
5 |
|
|
10 |
10 |
20 |
5 |
30 |
10 |
|
|
10 |
10 |
20 |
5 |
30 |
15 |
|
|
10 |
10 |
20 |
5 |
30 |
20 |
|
|
10 |
10 |
20 |
10 |
30 |
5 |
|
|
10 |
10 |
20 |
10 |
30 |
10 |
|
|
10 |
10 |
20 |
10 |
30 |
15 |
|
|
10 |
10 |
20 |
10 |
30 |
20 |
|
|
10 |
15 |
20 |
15 |
30 |
5 |
|
|
10 |
15 |
20 |
15 |
30 |
10 |
|
|
10 |
15 |
20 |
15 |
30 |
15 |
|
|
10 |
15 |
20 |
15 |
30 |
20 |
|
|
10 |
20 |
20 |
20 |
30 |
5 |
|
|
10 |
20 |
20 |
20 |
30 |
10 |
|
|
10 |
20 |
20 |
20 |
30 |
15 |
|
|
10 |
20 |
20 |
20 |
30 |
20 |
|
|
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules