alihadi
08-15-2015, 03:24 AM
Hi everyone,
Does anyone know how to generate random numbers between (1 & 4) with no repetition and sort them ascending using VBA excel without removing blank cells? I want to generate the numbers randomly in column (A) in random cells and sort them without removing the blank cells like in column (B) as shown in the attached excel file as an example. so I want the random numbers that have been generated with no repetition in column (A) to be sorted ascending in VBA without removing the blank cells as as shown in column (B).
I will be very grateful if you assist me in this matter.
Regards
Ali
Does anyone know how to generate random numbers between (1 & 4) with no repetition and sort them ascending using VBA excel without removing blank cells? I want to generate the numbers randomly in column (A) in random cells and sort them without removing the blank cells like in column (B) as shown in the attached excel file as an example. so I want the random numbers that have been generated with no repetition in column (A) to be sorted ascending in VBA without removing the blank cells as as shown in column (B).
I will be very grateful if you assist me in this matter.
Regards
Ali