|
Sub t1()
Dim x As Integer
For x = 1 To 3000 Step 1
Cells(x, 7) = Application.Small(Range("a" & x & ":e" & x), 1)
Cells(x, 8) = Application.Small(Range("a" & x & ":e" & x), 2)
Cells(x, 9) = Application.Small(Range("a" & x & ":e" & x), 3)
Cells(x, 10) = Application.Small(Range("a" & x & ":e" & x), 4)
Cells(x, 11) = Application.Small(Range("a" & x & ":e" & x), 5)
Next x
End Sub
|
|