Macro to pick random unique numbers from lsit

[dinesh_ltjd]

I have a list of around 200 unique ticket numbers in an excel file.
Now I want to pick randomly 60 unique ticket numbers from the list by VBA Code
Please guide me how can i do that

[xladept]

You could number them from 1 to 200 and then Randomly pick 60 numbers between 1 and 200 ensuring, of course against duplicates by putting them in an array perhaps?

Something like this:

Please Login or Register  to view this content.

[dinesh_ltjd]

Thanks Friend for your help :-)

[xladept]

You're welcome!