- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¦^´_ 13# Hsieh
Hsieh¤j¤j±z¦n¡G
·PÁ±zªº¼ö¤ß¨ó§U¡A¤u§@¤Wªº°ÝÃD¤w¸gOK
¦ý°ò©ó·Qn§âVBA¾Ç¦nªº¤ß±¡¡AÃö©ó³oÓµ{¦¡ªº¥©§®¤§³B¡A¬O§_¥i¥HÄ~Äò½Ð±Ð±z
³o´X¤Ñ§Ú¥ý¬Ý¤F¤@¥»VBA¤Jªùªº®Ñ
¤]¸Ô²Ó¬Ý¤F±zµoªíªº¤@¨Ç¤å³¹¡A¦p"Dictionaryª«¥óªº»{ÃÑ»PÀ³¥Î"¡B"VBAªº¼g§@§Þ¥©»P¼W¶i®Ä¯à"¡B"¾Ç²ß Excel VBAªº¤@¨Ç°ò¥»·§©À"µ¥¡AÀò¯q¨}¦h
¦ý¦¹µ{¦¡¤¤ªº¤@¨Çµ{¦¡½X§ÚÁÙ¬O¬Ý¤£À´
¦p¡G
For Each C In Ar
If C <> "" Then d1(C) = ""
If C = "©m¡@¦W" Then d1("¯Z¯Å") = "": d(A & "¯Z¯Å") = Replace(Replace(Replace(Replace(Replace(Replace(MyClass, "°ª", ""), "¦~", ""), "¯Z", ""), "¤T", 3), "¤G", 2), "¤@", 1)
d2(A.Value) = ""
d(A & C) = IIf(s > 20, "", "'") & A.Offset(, s).Text
'§ïÅÜ s ¥i§ïÅܦ¨ÁZ¥H¤å¦r©Î¼Æ¦r®æ¦¡
s = s + 1
Next
³o¬q¤¤¬O¦p¦ó±N¸ê®Æ«ü©w¶i¤Jd¡Bd1¡Bd2³o¤TÓDictionaryª«¥óªº©O?
°õ¦æ§¹d1(C) = ""«á¡Ad1ªºÅܼƤº®e¤¤³ºµM´N¥X²{count=1¡BItem1="¾Ç¸¹"¡H¯u¬O¤Ó¯«©_¤F
"d1("¯Z¯Å") = "": d(A & "¯Z¯Å") ="ªº»yªk¬O¬Æ»ò¡H§Ú·Q¥L¬O¬°¤F§â¯Z¯Å³oÓITEM«ü©w¶id1ªº²Ä¤T¶µ¡A¦ý¥L¬O«ç»ò¿ì¨ìªº©O¡H
¤£¦n·N«ä¡A¤p§Ì·M¬N©|¦³³\¦h¤£©ú¤§³B¡A
´Á«Ý±zªº¬Û§U¤§«á¡AÄ~Äò±´¯ÁVBAªº¥@¬É |
|