- ©«¤l
- 110
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 239
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-2
- ³Ì«áµn¿ý
- 2017-5-10
|
¦^´_ 9# GBKEE
ÁÂÁÂGBKEEª©¤jªº@¤ß«ü¾É¡A¨Ì±z´`´`µ½»¤ªº¤è¸ÕÅý§Ú¦Û¦æ§ä¥X§Únªºµª®×¤F¡A«D±`·PÁ±zªº¥Î¤ß^^- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim Target_Row As String, xi As Integer, xi_Row As String
- If Not Application.Intersect(Range("A4", Range("A4").End(xlDown)), Target) Is Nothing Then
- 'Intersectª«¥ó
- Target_Row = Target(, 1) & "," & Target(, 3) & "," & Target(, 5) '³o¸Ì¦Û¦æ×§ï ³s±µ¤£³sÄò¦ì¸m
- xi = 7
- Do While Sheets("sheet2").Cells(xi, 1) <> ""
- xi_Row = Join(Application.Transpose(Application.Transpose(Sheets("sheet2").Cells(xi, 1).Resize(, 3))), ",")
- If xi_Row = Target_Row Then Exit Sub
- xi = xi + 1
- Loop
- Sheets("sheet2").Cells(xi, 1).Resize(, 3) = Split(Target_Row, ",")
- 'Split ¨ç¼Æ: ¶Ç¦^¤@Ó³¯¦C¯Á¤Þ±q¹s¶}©lªº¤@ºû°}¦C¡A¥¦¥]§t«ü©w¼Æ¥Øªº¤l¦r¦ê¡C
- End If
- End Sub
½Æ»s¥N½X ³o¼Ë°õ¦æ¥Xªº¬O§Ú·Qnªºµ²ªG¡AÀ³¸Ó¨S¿ù§a?! |
|