Sub 抽样宏() With Sheet1 For n = 1 To 10 For i = 1 To 4 k = Int(Rnd() * 8) + 1 Cells(i + 1, 2 + n) = Cells(k + 1, 2) Next Next End WithEnd Sub