|
楼主 |
发表于 2012-2-29 16:48
|
显示全部楼层
本帖最后由 lxlaner 于 2012-2-29 16:49 编辑
- Sub 提取发货量()
- Dim i As Integer
- Dim x As Integer
- Dim Erow As Long
- Dim ErowChiMa As Integer
- TotalOrderToList.Range("G2:G65536").ClearContents
- Sheet5.Range("E2:E65536").ClearContents
- For i = 2 To TotalOrderToList.Cells(65536, 1).End(xlUp).Row
- For x = 2 To Sheet5.Cells(65536, 1).End(xlUp).Row
- ' If Sheet5.Cells(x, 5).Value = "" Then
-
-
-
- If TotalOrderToList.Cells(i, 1).Value = Sheet5.Cells(x, 1).Value And Left(TotalOrderToList.Cells(i, 4).Value, 3) = Left(Sheet5.Cells(x, 2).Value, 3) And _
- TotalOrderToList.Cells(i, 5).Value = Sheet5.Cells(x, 3).Value Then
- TotalOrderToList.Cells(i, 7).Value = TotalOrderToList.Cells(i, 7).Value - Sheet5.Cells(x, 4).Value
- Sheet5.Rows(x & ":" & x).Delete Shift:=xlUp
- x = x - 1
- End If
- 'End If
- Next x
- Next i
- End Sub
复制代码 就这段代码执行的速度最慢,就这个地方最需要优化,谢谢大侠了
|
|