Producing a list of 4 digit numbers

[nIgOl]

Hi everyone,

How can I produce a list of 4 digit numbers, where digits are not repeated? to give an example:

0124
0239
1236
2345
2346
etc.. etc..

but wouldn't include something like
0023
1223

Hopefully I explain myself.

 

[GorD]

See this thread.


http://www.mrexcel.com/board2/viewtopic.php?t=179001&highlight=

Set A1 to C for combinations

set A2 to 4 (numbers to select)

and list the 10 digits 0-9 below

The macro will do the rest