|
发表于 2016-8-10 10:39
|
显示全部楼层
本楼为最佳答案
冰是睡觉的水 发表于 2016-8-10 08:28
附件已上传
Sub test()
Dim r%, r1%
r = Sheet1.[I65536].End(xlUp).Row
r1 = Sheet1.[j65536].End(xlUp).Row
For i = r1 To r
If Cells(i, 6) <> "" Or Cells(i, 29) <> "" Then
Cells(i, 10) = Cells(i, 9) - Cells(i, 9) * Cells(i, 29) / 100
End If
Next
End Sub |
|