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

[µo°Ý] ¤£¦PÄæ¦ìªº¸ê®Æ¡A­n¦p¦ó°ïÅ|¨ì¦P¤@­Óªí®æ?

Sub yy()
Cells(9, 179).CurrentRegion.Copy Cells(9, 214)
For i = 186 To 212 Step 8
Cells(9, i).CurrentRegion.Offset(1, 0).Copy Cells(9, 214).End(4)(2, 1)
Next
End Sub

TOP

End(4)(2, 1)
¬Û·í©ó«öctrl+¦V¤UÁä¡AµM«á¦A«ö¤@­Ó¦V¤UÁä¡C

TOP

¨S¬ÝÀ´§Aªº¥Øªº¡C
Cells(9, m).CurrentRegion.Offset(1, 0).®Ú¥»¨S¸ê®Æ¡C

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD