Select Random rows and paste it in a different sheet.
 

Hi,

I have a database of 10000 rows in excel and i want a macro which will
select either 10% of data randomly or if a number is given (say 1150)
it should select those many number of row from the data base.

After selecting the data it should paste the data in a different
sheet.

I dont know how to use the rand() function in VBA. Can sum one help me
with the code.

Regards
Heera