Option Base 1 Sub gs() Randomize Dim i%, arr() r_end = Range("b65536").End(xlUp).Row Range("d6:d" & r_end).ClearContents r_end = r_end - 5 ReDim arr(r_end, 1) '重定义数组大小。 For i = 1 To r_end arr(i, 1) = Application.Ceiling((Rnd * (Range("h2").Value - Range("g2").Value) + Range("g2").Value), 1) Next i [d6].Resize(r_end, 1).Value = arr End Sub
Option Base 1 Sub gs() Randomize Dim i%, arr() r_end = Range("b65536").End(xlUp).Row Range("d6:d" & r_end).ClearContents r_end = r_end - 5 ReDim arr(r_end, 1) '重定义数组大小。 For i = 1 To r_end arr(i, 1) = Application.Ceiling((Rnd * (Range("h2").Value - Range("g2").Value) + Range("g2").Value), 1) Next i [d6].Resize(r_end, 1).Value = arr End Sub