|
代码不很精致,应该达到你的要求,但你的数据处理有点不一般- Sub try()
- On Error Resume Next
- Dim br()
- n = Range("F65536").End(3).Row
- arr = Range("B2:F" & n)
- ReDim br(1 To n, 1 To 1)
- For i = 1 To n
- a = arr(i, 1): b = arr(i, 3): c = arr(i, 5)
- If a Like "·*" Or i = n Then
- If i > 1 Then
- br(p, 1) = Mid(ss, 2, Len(ss) - 1)
- ss = "": s上 = ""
- End If
- p = i
- End If
- If b <> "" And c <> "" Then
- br(i, 1) = b
- ss = ss & "、" & b
- s上 = b
- ElseIf b = "" And c <> "" Then
- br(i, 1) = s上
- End If
- Next
- For i = 1 To n
- a = arr(i, 1): b = arr(i, 3): c = arr(i, 5)
- If a <> "" And p2 <> 0 Then
- br(p2, 1) = br(i, 1)
- p2 = 0
- End If
- If a <> "" And Not a Like "·*" And c = "" Then
- p2 = i
- End If
- Next
- [J2].Resize(n - 1, 1) = br
- End Sub
复制代码 |
|