¶¡Â_¿é¤J®É ¦p¦óÅýµ{¦¡¤]¥i¥H±a¥X¸ê®Æ
- ©«¤l
- 92
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 195
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-8-15
- ³Ì«áµn¿ý
- 2011-8-11
|
¦^´_ 7# hugh0620
¥Hoobirdª©¥Dªºµ{¦¡½X¨Óק諸¸Ü
²Ä2¦æ§ï>3, ¦A·s¼W²Ä5¦æ§Y¥i~- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Or Target.Column > 3 Then Exit Sub
- On Error Resume Next
- Target(1, 2) = Sheet2.[b:b].Find(Target, , , 1)(1, 2).Value
- Target(1, 2) = Sheet3.[b:b].Find(Target, , , 1)(1, 2).Value
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|