Sub 标准循环()
Dim rg As Range
For Each rg In Range("h4:h100")
If rg.Offset(0, -6) <> "总计" Then
rg = rg.Offset(0, -1) * rg.Offset(0, 1)
End If
Next rg
End Sub
Sub 标准循环()
Dim rg As Range
For Each rg In Range("h4:h100")
If rg.Offset(0, -6) <> "总计" Then
rg = rg.Offset(0, -1) * rg.Offset(0, 1)
End If
Next rg
End Sub