Jim,

I need random numbers for BOTH Row 3 and Col B.

Have I answered your question correctly?

Bob



"Jim Cone" wrote:

Bob,
I think your requirements are a little too strict. <g
You only allow ten unique numbers (0 to 9) and ten cells in each range.
Are you just trying to random sort all ten numbers?
--
Jim Cone
Portland, Oregon USA



"robert morris"

wrote in message

I need help with a VBA for creating NON-REPEATING random numbers between 0-9
in Col B4:B13 and Row C3:L3

Bob