randomly select a row from a excel sheet

[redshirtme]

how to randomly select a row number from excel sheet? I am simulating lottery game.


thx

[MJBNET]

Dim RandomRow As Long
'RandomRow = 'whatever code you'd use to pick a random number between 1 & 65536
Rows(RandomRow).EntireRow.Select

[MJBNET]

this works from in excel

Sub test()
    Dim RandomRow As Long
    Randomize
    RandomRow = Int((65536 * Rnd) + 1)
    Rows(RandomRow).EntireRow.Select
End Sub