- ©«¤l
- 37
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 63
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-25
- ³Ì«áµn¿ý
- 2016-5-24
|
¦^´_ 3# GBKEE
ÁÂÁ§Aªº¸Ñµª
§Aªº»y¥y¤ñ§ÚªºÂ²³æ«Ü¦h, ¥H¤W3Ó°ÝÃD§Ú¬Q¤Ñ¤w¸g¸Ñ¨M¤F.
¥t¥~¨ä¹êcell double click & copy ¤w§ä¨ì¤èªk, ¦ý¬O¦pªG§Ú¦b 1¦Ü8¦æ¤¤¼W¥[N¦æ¼Æ , «ü©wªº Range ½d³ò´N¥¢¥h®Ä¥Î,
¬O¤£¬On¥Îvlookup offset ¨Ó³]©w (¦pA9¬° [¶µ¥Ø¦W] >> vlookup ¶µ¥Ø¦W offset Range ¾É¦V 10,0 : 20,3 ),
§Ú¥uÃÑvlookup ¨ç¼Æformula ¦ýmacro ´N¤£À´«ç¼g, ½Ð°Ýn«ç§ï?- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- If Not Intersect(Range("A10:D20"), Target) Is Nothing Then
- Application.EnableEvents = False
- Range("E20") = Target
- Application.EnableEvents = True
- Range("E20").Select
- Selection.Copy
- End If
- End Sub
½Æ»s¥N½X |
|