- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¸Õ¸Õ¬Ý¡G- Option Explicit
- Private Sub CommandButton1_Click()
- Dim i, lastRow As Integer
-
- lastRow = [A1].End(xlDown).Row '¨ú±oAÄæ³Ì¤U¤@¦æ
-
- For i = 2 To lastRow
-
- '¦pªG ·í¤é³Ì°ª»ù>¾ú¥v³Ì°ª»ù, «h
- If Cells(i, 3) > Cells(i, 4) Then
- Cells(i, 4) = Cells(i, 3) '¾ú¥v³Ì°ª»ù=·í¤é³Ì°ª»ù
- End If
- Next
- End Sub
½Æ»s¥N½X |
|