|
发表于 2016-10-19 17:08
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- r = [a65536].End(3).Row
- arr = Range("a1:a" & r)
- s = 1
- For i = 1 To r
- If Len(arr(i, 1)) > 0 Then
- e = i
- If e > s Then
- x = Val(arr(s, 1)): y = Val(arr(e, 1))
- xmax = IIf(x > y, x, y): xmin = IIf(x < y, x, y)
- For j = IIf(s = 1, 1, s + 1) To e - 1
- arr(j, 1) = Application.WorksheetFunction.RandBetween(xmin * 10000, xmax * 10000) / 10000
- Next
- s = i
- End If
- End If
- Next
- Range("a1:a" & r) = arr
- End Sub
复制代码 |
|