|
发表于 2011-12-13 11:18
|
显示全部楼层
本楼为最佳答案
本帖最后由 mxg825 于 2011-12-13 11:23 编辑
- Sub aa()
- Dim ARR, X&, Y&
- ARR = Sheets("日数据").UsedRange
- For X = 3 To UBound(ARR)
- ARR(X, 7) = ""
- ARR(X, 8) = ""
- For Y = 3 To UBound(ARR)
- If ARR(X, 6) = ARR(Y, 3) Then
- ARR(X, 7) = ARR(Y, 4)
- ARR(X, 8) = ARR(Y, 5)
- End If
- Next
- Next
- Sheets("日数据").Cells.ClearContents
- Sheets("日数据").Range("A1").Resize(UBound(ARR), UBound(ARR, 2)) = ARR
- MsgBox "搞定", , "Mxg825 提示您"
- End Sub
复制代码 |
|