- ©«¤l
- 41
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 71
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-30
- ³Ì«áµn¿ý
- 2012-8-25
|
ÁÂÁª©¥D:D
¥t¥~¤@Ó°ÝÃD:
Sub Remain_M()
For i = 0 To 5
Worksheets.Add
ActiveSheet.Name = "Im=" & i
Worksheets("Im=" & i) = Demand_M_2nd(Im)
(©³½uªº³¡¤À¸Ó¦p¦ó§ó§ï)
Next
End Sub
Function Demand_M_2nd(ByVal Im As Integer)
For i = 3 To 5
If Worksheets("Sheet1").Cells(i, 2).Value - Im > 0 Then
Cells(i, 2).Value = Cells(i, 2).Value - Im
Else
Cells(i, 2).Value = 0
End If
Next
End Function |
|