Look for 'help' on Randomize and rnd
like below:
'Returns a random number from one(1) to nine(9)
Randomize
Random19 = Int(9 * Rnd + 1)

You will have to setup your own macro based on your sample.

DanR

"mecivil" wrote in message
...
I have to develop a user-defined function that can
be used to do random sampling of one or more elements from a sampling
frame listed in a range in Excel
When two or more elements are
sampled, the sampling needs to be done without replacement.

How can i achieve this?