- ©«¤l
- 31
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-10-4
- ³Ì«áµn¿ý
- 2017-10-17
|
- Sub diffab()
- For i = [a65536].End(xlUp).Row To 1 Step -1
- If IsNumeric(Cells(i, 1)) And Cells(i, 1) <> "" Then
- a = Cells(i, 1)
- Exit For
- End If
- Next i
- For i = [b65536].End(xlUp).Row To 1 Step -1
- If IsNumeric(Cells(i, 2)) And Cells(i, 2) <> "" Then
- b = Cells(i, 2)
- Exit For
- End If
- Next i
- MsgBox a - b
- End Sub
½Æ»s¥N½X ¦^´_ 1# ziv976688 |
|