|
发表于 2012-1-17 20:56
|
显示全部楼层
本楼为最佳答案
本帖最后由 爱疯 于 2012-1-17 20:57 编辑
东方智彩 发表于 2012-1-17 20:38
谢谢爱疯版主,提取正确,能否将提取的紧密显示,去掉CA列中间的空行
- Sub tq()
- Dim A(), B, C, i&, j&, s&
- With Sheets("sheet1")
- i = .Range("a2").End(xlDown).Row
- A = .Range("a2:a" & i).Value
- ReDim C(1 To UBound(A), 1 To UBound(A, 2))
- For i = 1 To UBound(A)
- B = Split(A(i, 1), " ")
- If B(2) - B(0) = 2 Or B(3) - B(0) = 3 Or B(4) - B(0) = 7 Then
- s = s + 1
- For j = 0 To 4
- C(s, 1) = C(s, 1) & Format(B(j), "00") & " "
- Next j
- End If
- Next i
- .Range("ca2:ca65536").ClearContents
- .Range("ca2").Resize(s, 1) = C
- End With
- End Sub
复制代码 |
|