Random seclection of data from a list in exl
Closed
Pednekar
-
Jul 16, 2009 at 12:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 17, 2009 at 01:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 17, 2009 at 01:41 AM
Related:
- Random seclection of data from a list in exl
- Display two columns in data validation list but return only one - Guide
- Mobile number list with name - Guide
- Counter strike 1.6 cheats list - Guide
- Tmobile data check - Guide
- How to change your best friends list on snapchat to 3 - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 17, 2009 at 01:41 AM
Jul 17, 2009 at 01:41 AM
to get random numbers between 1 and 100 use this macro
modify to suit you and use these cell values suitably in your main macro
Sub test() Range("e1").Formula = "=randbetween(1,100)" Range("e1").Copy Range("e2:e20") Range("e1:e20").Copy Range("e1").PasteSpecial xlPasteValues End Sub
modify to suit you and use these cell values suitably in your main macro