|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub j()
Dim i, r, j%, Arr1, m, n
Arr1 = Sheets("sheet1").Range("A1:M5000")
ReDim arr2(1 To 1, 1 To UBound(Arr1) - 2)
For i = 3 To UBound(Arr1)
If Len(Arr1(i, 2)) > 0 Then
n = UBound(Arr1, 2)
For r = 2 To UBound(Arr1, 2) - 2
With Sheets("sheet1")
If .Cells(i, r).Interior.ColorIndex = 6 Then
j = j + 1
arr2(1, j) = r
If j > 1 Then
m = arr2(1, j) - arr2(1, j - 1) - 1
n = Application.Min(n, m)
End If
End If
End With
Next
If j <= 1 Then
Arr1(i, 13) = "没有符合要求的数据"
Else
Arr1(i, 13) = n
End If
j = 0
m = 0
End If
Next
Sheets("sheet1").[a1].Resize(UBound(Arr1), UBound(Arr1, 2)) = Arr1
End Sub
|
评分
-
1
查看全部评分
-
|