|
- Sub test()
- Dim i As Integer
- Dim ar(1 To 101)
- Dim s, s1, s2
- s = Range("o4")
- For i = 1 To 101
- s1 = Application.Min(Range(Cells(i + 3, "n"), Cells(103, "n")))
- s2 = Application.Max(Range(Cells(i + 3, "m"), Cells(103, "m")))
- ar(i) = Round((s - s1) / (s2 - s1) * 100, 2)
- Next
- Range("r4").Resize(101, 1) = Application.Transpose(ar)
- End Sub
复制代码 |
|