|
- Sub xx()
- Dim n&, arr, brr, i&
- With Sheet1
- n = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("E2:F" & n)
- brr = .Range("F2:G" & n)
- For i = 1 To n - 1
- If brr(i, 1) <> "" Then
- arr(i, 1) = brr(i, 1)
- arr(i, 2) = brr(i, 2)
- End If
- Next
- .Range("E2:F" & n) = arr
- .Columns("G:G").ClearContents
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|