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

[µo°Ý] ½Ð±Ð³o¬q

[µo°Ý] ½Ð±Ð³o¬q

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-7-22 10:29 ½s¿è

½Ð°Ý¦U¦ì¤j¤j
¥H¤U³o¬qµ{¦¡½X¬O¤°»ò·N«ä§r?
·PÁ±z


For Each a In Range([A2], [A65536].End(xlUp))  
  Sheets("°O¿ý").[A65536].End(xlUp).Offset(1, 0).Resize(, 12) = a.Resize(, 12).Value
   a.Resize(, 1) = ""
   a.Offset(, 2) = ""   ¡u³o¬O¦V¥k²MªÅ2®æ?¡v
   Next
End Sub
ª÷¤ò­¸

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-7-22 10:30 ½s¿è

½Ð°Ý¦U¦ì¤j¤j
§Ú¤W¤@­Ó°ÝÃD¥D­n¬O­n°Ý¥H¤Uµ{¦¡½Xªº·N«ä
¤]·PÁÂH¸òG¤jªº«ü¥¿
¥Ñ©ó§ä¤£¨ì¦^ÂÐ¥\¯à
©Ò¥H¥u¦n¦Aµo°Ý¤@¦¸
¤£¬O¬G·NÁÈ¿n¤À
¥H¤U³o¬qµ{¦¡½X¬O¤°»ò·N«ä§r?
·PÁ±z


For Each a In Range([A2], [A65536].End(xlUp))   
Sheets("°O¿ý").[A65536].End(xlUp).Offset(1, 0).Resize(, 12) = a.Resize(, 12).Value
   a.Resize(, 1) = ""
ª÷¤ò­¸

TOP

¦^´_ 5# Hsieh

H¤j
·PÁ±z
ª÷¤ò­¸

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD