Generating of unique random set length numerical codes

[coreytroy]

I am after a way to have a cell highlighted to input the code length, between 4 - 7 digits say cell A1
Each code can only use a numerical value between 0 - 9, and not use the same digit more than once.
Eg. 6 digit code could be 371409, but could not be something like 374380, as 3 is used twice.

I would like a random list generated down column A from A2:A1000.

How would this be accomplished?

[mehmetcik]

I know that there is probably an array formula to do this.

But my prefferred route would be a custom Macro.

It will take ten minutes to write. BRB

Please Login or Register  to view this content.

[kalak]

vba macro

Please Login or Register  to view this content.

[mehmetcik]

If the cells are formatted as text then line 200 can be modified to:

Please Login or Register  to view this content.

[coreytroy]

I know that there is probably an array formula to do this.

But my prefferred route would be a custom Macro.

It will take ten minutes to write. BRB

Please Login or Register  to view this content.

Thank you very much for the reply, and workbook.
Seems to be te trick.
Modified to the below to suit a set code length:

Please Login or Register  to view this content.

ONLY issue i am having, is that any changes to other cells in the sheet, changes the codes each time.

[mehmetcik]

Try this version.

Two Changes
1. it stops the UDF working if B2 is changed to 0
2. it stops picking numbers if it has the number of digits specified by B2
[ Similar to your modification, but why pick 5 digits if you are going to ditch them?]

Please Login or Register  to view this content.