[已解决]EXCEL高手用VBA将A和B列产生随机数

vbyou127

EXCEL高手用VBA将A和B列产生随机数

最佳答案

月排行榜 / 总排行榜

02761752696

2016-3-25 19:06

Sub sjs()
  For i = 1 To 65535
    Cells(i, 1).Value = Application.RandBetween(1, 99)
    Cells(i, 2).Value = Application.RandBetween(1, 99)
  Next
End Sub

跳转到最佳答案楼层

02761752696

Sub sjs()
  For i = 1 To 65535
    Cells(i, 1).Value = Application.RandBetween(1, 99)
    Cells(i, 2).Value = Application.RandBetween(1, 99)
  Next
End Sub

02761752696

看看 吧