1# saslovime
Worksheets("月报出口-2010").Activate
With Worksheets("月报出口-2010")
For i = 2 To 316
If Left(.Cells(i, 4), 2) = "万" Then
.Cells(i, 6) = Mid(.Cells(i, 4), 3)
.Cells(i, 7) = .Cells(i, 5) / 10000
.Cells(i, 9) = "FLAG"
Else
.Cells(i, 6) = .Cells(i, 4)
.Cells(i, 7) = .Cells(i, 5)
End If
Next
End With
应该是cells而不是cell