Combination with criteria

[tonysmile]

Hello all!

I'm stuck... lots of searching and lots of dead ends. I'm hoping that someone here can help!
The macro I'm looking to build has 2 parts to it.

Here's what I would like to do:

PART 1 -
I would like to create a macro that gives me 6 numbers (which range from 1 to 45 and only occur once in the row) with 1 number in each cell.
The cells are A, B, C, D, E, F.
I would like the numbers to be printed in ascending order.
Once it has done this to then print the next combination in the row below. So on and so forth until all combinations have been done.

i.e.

	A	B	C	D	E	F
Row 1	1	2	3	4	5	6
Row 2	1	2	3	4	5	7

<tbody>
</tbody>

I know that there are over 5 million different combinations so I have put in some parameters to narrow it down and here is where it gets tricky...

PART 2 -
IF the sum of the combination is less than the value in cell H1 OR greater than the value in H2 then I want the macro to NOT print the result otherwise, print the result and move on to the next combination to check that it meets the criteria.

To add to the confusion...
IF the sum of the first 2 numbers of the combination is less than the value in cell H5 OR greater than the value in H6 then I want the macro to NOT print the result otherwise, print the result and move on to the next combination to check that it meets the criteria.

After every line printed onto the sheet, print the next line on the row below.

 

[PGuru]

Assuming that a) you're happy to have a single piece of code, b) you don't want to display the rejected combinations, then this seems achievable.

You need a variable to count the row number, and 6 variables with which to loop round the numbers from 1 to 45.

Nest the 6 loops which populate columns A-F, then in the lowest one, check if your various criteria are being met. If they are, increase the row counter. If not, don't - the next loop will then overwrite the rejected one.

Once the loops have completed, re-check the last line (in case it should be rejected) and clear it if necessary.

 

[tonysmile]

single piece of code preferred!

I should have added that my programming skills are poor and I only have a basic understanding of coding so this has made everything harder.

It would be amazing if someone could provide me with the code for the macro

 

[PGuru]

Sorry if it sounds patronising, but there's never a bad time to start/practise one's coding!

Build it up in modular sections - do one loop, then do another. Write the filter criteria, check it works, then drop it in.