|
- Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
- Sub 跑马()
- Dim i%, x%, rng As Range, n%, j%
- Dim col As New Collection
- With Sheet1
- For i = 8 To 12
- col.Add .Cells(5, i)
- Next
- For i = 6 To 9
- col.Add .Cells(i, 12)
- Next
- For i = 11 To 8 Step -1
- col.Add .Cells(9, i)
- Next
- For i = 8 To 6 Step -1
- col.Add .Cells(i, 8)
- Next
- End With
- For j = 1 To 3 '跑三圈
- For i = 1 To col.Count
- Sleep 100 '延迟
- DoEvents
- col(i).Select
- Next
- Next
- n = Int(Rnd() * 16) + 1
- For i = 1 To n
- Sleep 60 '延迟
- DoEvents
- col(i).Select
- Next
- End Sub
复制代码 |
|