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

[µo°Ý] »¼´î½Æ»s¼ÐÃD

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-7-13 21:50 ½s¿è

¦^´_ 10# samwang
¨S¦³Ãö«Y!ÁÂÁ±zªº¦^ÂСC
¥i§_½Ð±Ð~
Sheets(Array("·Ç7¶i8", "·Ç6¶i7", "·Ç5¶i6", "·Ç4¶i5", "·Ç3¶i4", "·Ç2¶i3")).Select
³o¬q»yªk¥¿½T¶Ü?
¬°¤°»ò¥]¬A"·Ç1¶i2"¤]·| ±NSheets("DATA").Range("A" & StrRng - 1, "I" & mthcount - 1).Copy ¨ì.Range("AL2").Resize(1, mthcount - StrRng + 1)?
¬O¤£¬O¨ü¨ì¦C88  "For I = 1 To 7"  ªº¼vÅT?
ÁÂÁ±z!

TOP

¦^´_ 11# ziv976688


Sheets(Array("·Ç7¶i8", "·Ç6¶i7", "·Ç5¶i6", "·Ç4¶i5", "·Ç3¶i4", "·Ç2¶i3")).Select
³o¬q»yªk¥¿½T¶Ü? --> ¥¿½T

¬°¤°»ò¥]¬A"·Ç1¶i2"¤]·| ±NSheets("DATA").Range("A" & StrRng - 1, "I" & mthcount - 1).Copy ¨ì.Range("AL2").Resize(1, mthcount - StrRng + 1)? --> ¤£¥i¯à¦]¬°¤W­±¨º¬q¦Ó¼vÅT"·Ç1·Ç2"¡A¤@©w¬O¨ä¥¦ªº¦a¤è¾É­P

TOP

¦^´_ 12# samwang
ÁÂÁ±zªº­@¤ß»¡©ú©M«ü¾É¡C
§Ú¦A·Q·Q¬Ý
·P®¦³á

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD