pick3

[piter]

Please help me in the following =
Create a planilia in Excel, to create pairs with the smallest to the largest digit
Example 457 = pair with the smallest and largest digit = 47. But obeying the three positions in pick3
In the example under 4 digits 1 and is positioned higher in the 3rd position, the digit
In the middle goes like this case is 4:07 = 5.6. gave 5
= 749 Another example is the smallest 4-digit top nine of the pair taking the 2nd position and three
The seventh digit was between 4 and 9 = 5,6,7,8
Purpose of the macro is to create pairs in three positions pick3 rotation with the lowest and highest digit
The third digit is the lowest and highest type OK to filter the smaller more
Use the registration of designs and see the positions of the lower frequencies for more
It may just be ok to create the macro. thanks
pick3
1 st 2 nd 3 rd
4 5 7
7 8 9 ...
here's the list of registered sweepstakes picks opçap copy and paste or type!

 

[Scott Huish]

Link the macro to the button

Or use an ActiveX control button and use the code inside the Sub.End Sub for it.

or hit ALT-F8 and run the macro.

 

[piter]

Hot peppe r Hello, this is as an array of 6 rows and 10 columns in a matrix
10x6 = 60 positions 60 positions ok this matrix has six rows = 0,1,2,3,4,5, OK
and 10 columns, I need a macro to do just four matches all six digits) (0,1,2,3,4,5)
example
0 0 0 0
2 0 0 5
0 0 4 5
2 3 3 5 ....
Hotpepper can use the formula or table karnaugl ok. Goal is to create a matrix
as a digital circuit, but the use of an array of numbers, should take a thousand or more lines = 0 0 0 1, the macro tnde ok thousand combinations to create this type of karnaugl map, a list that is probably close to 100 %, for example, looking for group 4 = 0,1,2,5
The list will be ok, thanks
matrix =
Hotpepper not look endings (0,1,2,3,4,5,6, 7,8,9) do not enter these macro ok
Only these = 0,1,2,3,4,5

 

[piter]

eis a matriz 10x6
<TABLE style="MARGIN: auto auto auto 2.75pt; WIDTH: 230pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 3.5pt 0cm 3.5pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=307><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

1<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

3<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

4<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

5<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

6<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

7<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

8<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

9<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

10<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

11<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

12<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

13<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

14<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

15<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

16<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

17<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

18<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

19<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

20<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

21<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

22<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

23<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

24<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

25<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

26<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

27<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

28<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

29<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

30<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

31<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

32<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

33<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

34<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

35<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

35<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

37<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

38<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

39<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

40<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

41<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

42<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

43<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

44<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

45<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

46<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

47<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

48<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

49<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

50<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

51<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

52<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

53<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

54<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

55<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

56<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

57<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

58<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

59<o></o>​

</TD><TD style="BORDER-BOTTOM: #e0e0e0; BORDER-LEFT: #e0e0e0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 3.5pt; WIDTH: 23pt; PADDING-RIGHT: 3.5pt; HEIGHT: 15pt; BORDER-TOP: #e0e0e0; BORDER-RIGHT: #e0e0e0; PADDING-TOP: 0cm" vAlign=bottom width=31 noWrap>

60<o></o>​

</TD></TR></TBODY></TABLE>

 

[Scott Huish]

Sub test()
Range("B1") = 1
Range("B1:B6").DataSeries , , , 10
Range("B1:K6").DataSeries
End Sub

 

[piter]

Hello, hotpepper, the macro must generate all combinations with the digits 0, 1, 2, 3, 4.5
Example
0000
0001
0111 ... ate 5
The array of 10x6 was for you to understand better, ok the macro must generate conbinçao as the karnaugl map
Cannot repeat positions, and cannot be repeated, ok conbinaçoes, can see ok
sao 6 digits (0, 1, 2, 3, 4, 5) closing or conbinando by 4
example = 0000 0001. ...

 

[piter]

Hello, HOTPEPPER the formula that you did, just makes the array is not nothing. , the array was only to understand, I need the conbinaçoes
What the macro tends to do are the combinations using the digits = 0, 1, 2, 3, 4.5
Combining by or closing 4 group
Example of how will stay
0000
0001
0010 .... until arriving in digit 5
The combinations may not have repetitions in position ok like the table of karnaugl thanks

 

[Scott Huish]

I've done the best I can do. I hope someone will be able to help you.

 

[piter]

Hello, hotpepper the array that you showed is the array of game, was not to make the array,
Because the array is only copy of the card, this is not! No!
I need the conbinçoes example
0000
0001
0002....
Must have some 1200 conbinaçoes or you use the digits 0, 1, 2, 3, 4.5
To combine for 4?

 

[piter]

Hello hot, found the formula ready, what you tend to do is only change where has 0000 5555
Switch to 000 8888 and where has 5 change to 8. the rest is all the same, I'm afraid to change the formula. Can you change? Thank you perhaps the letters, but need to see ok, need guidance to activate the macro! Thank you

Sub all_comb()
'macro to create all comb 0000-5555
Ln = 1 ' start display at line 1
For w = 0 To 5: For x = 0 To 5: For y = 0 To 5: For z = 0 To 5
Cells(Ln, 1) = w: Cells(Ln, 2) = x: Cells(Ln, 3) = y: Cells(Ln, 4) = z
Ln = Ln + 1 ' move down to next line
Next z: Next y: Next x: Next w ' complete loops
End Sub

 

[piter]

Hello forgiveness, where would excuse the fact is 8888 7777
Then he goes 5 and 7, 8 and the 888 was my mistake right and 7777 is 7 ok! Sorry