I need a code that can randomly select a set of numbers each time the macro is ran.
I already recorded a macro but I did it to ramdon select from A-J in terms of roll and this selection should be from the already generated numbers I have in the sheet.
This what I have recorded
Sub copyWeigths_sheet2()
' copyWeigths_sheet2 Macro
Sheets("WEIGHTS").Select
Range("A9:J9").Select ' this could be A28 to J28
Selection.Copy
Sheets("Sheet2").Select
Range("V501:AE501").Select
ActiveSheet.Paste
End Sub
Thanks.
Bookmarks