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

[µo°Ý] ¦h­Ó½d³ò¿ï¾Ü¥ÑÅܼƨú¥N

[µo°Ý] ¦h­Ó½d³ò¿ï¾Ü¥ÑÅܼƨú¥N

­ì¥»¿ý¤Uªº¥¨¶°¬°
Range("A20:N1200,U20:V1200,Z20:Z1200,AE20:AF1200,AJ20:Ak1200,AM20:AP1200").Select
    Selection.Copy
---------------------------------------------------------------------
³Ì«áªº1200(row) ·Q¥ÑbÄæ ªº³Ì«árow¨ú¥N.
dim bb
Set bb = Range("b65536").End(xlUp).Offset(0)
CC = bb.Row
±µ¤Uªº»yªk¬O??

¤w¸Ñ¨M ¥Î Union
With Sheets("Sheet6")
Dim bb, d, e, F, G, H, I
Set bb = .Range("b65536").End(xlUp).Offset(1)
CC = bb.Row
Set d = .Range("A20:N" & CC)
Set e = .Range("u20:v" & CC)
Set F = .Range("Z20:Z" & CC)
Set G = .Range("AE20:AF" & CC)
Set H = .Range("AJ20:AK" & CC)
Set I = .Range("AM20:AP" & CC)
End With
   Union(d, e, F, G, H, I).Copy

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD