how to generate random number with unique sequense

Have u ever tried RND for random number generation in excel VBA?

Using RND for random number generation does not guarantee a unique number every time. It will generate same sequence every time when u r using multiple times.

This can be avoided by using a simple statement whenever u use RND function.

randomize

Use this statement before calling RND function for random number veneration.

If lower limit =2
Higher limit = 10

Num = Cint((10-2+1)*RND+2)

It will generate same sequence every time when u run this code.

Randomize
Num = Cint((10-2+1)*RND+2)

It will generate a new different random sequence from 2 to 10 every time.