|
发表于 2014-1-22 20:51
|
显示全部楼层
本楼为最佳答案
- Sub t1()
- Dim i As Integer, j As Integer
- Dim Rowcount As Integer
- Dim se5 As String, sf5 As String
- Dim se6 As String, sf6 As String
- Dim k As Integer, l As Integer
- For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
- Rowcount = Cells(i, 1).MergeArea.Count
- If Rowcount = 1 Then
- If Cells(i, 2) Then
- se5 = se5 & Cells(i, 1).Value
- Else
- se6 = se6 & Cells(i, 1).Value
- End If
- Else
- For j = 1 To Rowcount
- If Cells(i + j - 1, 2) > 0.5 Then Exit For
- If Cells(i + j - 1, 2) < 0.5 Then
- k = k + 1
- ElseIf Cells(i + j - 1, 2) = 0 Then
- l = l + 1
- End If
- Next j
- If k = Rowcount Then
- sf6 = sf6 & Cells(i, 1).Value
- ElseIf l = Rowcount Then
- se6 = se6 & Cells(i, 1).Value
- End If
- i = i + Rowcount - 1
- k = 0
- l = 0
- End If
- Next i
- [e5] = se5
- [f5] = sf5
- [e6] = se6
- [f6] = sf6
- End Sub
复制代码 没看到结果,不知这个结果是否满足要求 |
|