"Paul Black" wrote:
Unfortunately the UDF produces replica numbers.
What I would prefer is a Sub that produces 5,6,7
or whatever number combinations without replacement
until ALL the numbers have been used.

It does exactly that if you put =uniqRandBetween(1,34) into 34 different
cells in any arrangement that you wish. (Previously, you mention 6 rows of
5 and 1 row of 4.)