|
Sub 内容少的2()
''st = Timer
Sheet1.[E12:G3100].ClearContents
arr = Sheets("数据区").Range("V6:X3006")
ReDim brr(1 To UBound(arr, 1), 1 To 16) ''
For i = 1 To UBound(arr, 1)
If arr(i, 1) > 0 And arr(i, 1) < 2 Then brr(i, 1) = "项目1"
If arr(i, 2) > 2 And arr(i, 2) < 6 Then brr(i, 2) = "项目2"
If arr(i, 3) > 6 And arr(i, 3) < 8 Then brr(i, 3) = "项目3"
If arr(i, 3) > 5 And arr(i, 3) < 7 Then brr(i, 4) = "项目4" '
If arr(i, 3) > 2 And arr(i, 3) < 7 Then brr(i, 5) = "项目5"
If i < UBound(arr) Then
brr(i, Abs(arr(i, 1) - arr(i + 1, 1)) + 6) = Abs(arr(i, 1) - arr(i + 1, 1)) '错在这一句,提示下标越界!
End If
'' 这句代码是想把,arr = Sheets("数据区").Range("V6:X3006"),这个数组里面单元格V6-V7的绝对值,
Next
Sheets("测试").[E12].Resize(UBound(brr, 1), UBound(brr, 2)) = brr
''MsgBox Timer - st
End Sub
最后一条不计看看 |
|