ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBAµ{¦¡¹J¨ì²Ä¤@­Ó­ÈÂ^¨ú°ÝÃD

Sub T20130515_1()
Dim xR As Range, J%, K%, T$
For Each xR In Range([A1], [A65536].End(3))
¡@¡@T = xR(1, 2):¡@¡@J = InStr("¶R½æ", T)
¡@¡@If T <> "" And J > 0 And J <> K Then xR(1, 3) = xR: K = J
Next
End Sub

²¤¹L¢ÐÄæªÅ®æ¤Î¨ä¥L¦r¤¸¡A¥uÀË´ú¡e¶R¡D½æ¡f¨â¦r¬O§_¦³§ó´«¡A
¥ç§Y¡A¡e¶R¡D½æ¡f¨â¦r¤£³sÄò®É¤]¥i§PÂ_¡A
¢Ù­È·|«O¯d¤W¤@­Ó¦r¬O¡e¶R¡f©Î¡e½æ¡f¡A¦A»P¢Ø­È¤ñ¹ï¡A§Y¥i§PÂ_¡I

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD