Generate a list permutation numbers without duplicate

[jamshoot]

Hi all

Seek help.
My excel level is just average with only little knowledge in VBA.
I am looking for a simple VBA to self generate numbers with a given number with no duplicate.

Example:
In A1, I have 1234.
A simple VBA which can generate number in a column B1, a series of numbers based on A1 (1234) until there is no repeat.
I have tried one past VBA done by fellow guru. But it does not work on numbers. When I used it, there are duplicates :

http://www.mrexcel.com/forum/excel-questions/821222-all-possible-combinations-without-repeating.html
Any guru can help.

Cheers

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ers-no-duplicate-post5251315.html#post5251315

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).