|
昨天做好了的数组方式的:
- Sub suaa()
- rw = Cells(Rows.Count, 7).End(3).Row
- Rng = Range("E2:G" & rw)
- ReDim arr(1 To UBound(Rng), 1 To 3)
- a = 1
- Do While a < UBound(Rng) + 1
- x = x + 1
- If Rng(a, 2) = "基本解释" Then
- arr(x, 1) = Rng(a, 1): arr(x, 2) = Rng(a, 2)
- arr(x, 2) = Rng(a, 2): p = Rng(a, 3)
- b = a + 1
- If b < UBound(Rng) + 1 Then
- Do While Rng(b, 2) = ""
- If Rng(b, 2) = "" Then
- p = p & "*" & Rng(b, 3)
- End If
- b = b + 1
- Loop
- End If
- arr(x, 3) = p
- a = b
- Else
- arr(x, 1) = Rng(a, 1): arr(x, 2) = Rng(a, 2): arr(x, 3) = Rng(a, 3)
- a = a + 1
- End If
- Loop
- Range("A1").Resize(x, 3) = arr '写入到A:C列
- End Sub
复制代码 |
评分
-
查看全部评分
|