I'm forgetting my manners, thank you for the kind comments about the code and
I'm glad I could help. It's getting very late now here in the UK, check back
tomorrow, I'm intrigued by this and I think I'll have a go at a generic
solution for 3,4 or 5 numbers but right now a couple of vodkas and bed.

Mike

"Mike H" wrote:

Hi,

It would be a complete re-write to do it for 3 or 4 because for (say) 3 you
would need to add 3 unused numbers. I did consider trying to make the code
generic for 3,4 or 5 but quickly concluded that it would be a lot more
complicated then I initally thought.

Mike

" wrote:

Hi Bernard, I did google "excel permutations combinations" and went
through all the 'Combinations' previous posts
but unfortunately could not find any code that does anything like the
code Mike has written...

Mike, that code is fantastic! thankyou very much, there is NO way I
could have written it.
you are right, I thought there would be 252 combo's but I was wrong.

Q. Where in the code would I adjust it to generate 4's and the 3's
I am not pretending to understand your code, because I don't.
Is the alteration something to do with the fourthno and fifthno?

Once again...cheers

Ste