Thread: Random selection of rows.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chavan2000 via OfficeKB.com chavan2000 via OfficeKB.com is offline
external usenet poster
  
Posts: 2
Default Random selection of rows.
Hi,

I have a database of 10000 rows in excel and i want a macro which will select
10%(10% of 10000 rows) of rows randomly and paste it in a different sheet.

And if a user mentions a specific number, say 1150 rows then the macro should
select those many rows randomly and paste it in a different sheet.

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

Regards
Heera

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200901/1

Reply With QuoteReply With Quote