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

[µo°Ý] ³o¬qvba­þ¸Ì¼g¿ù¤F¡H

[µo°Ý] ³o¬qvba­þ¸Ì¼g¿ù¤F¡H

Union(Range(Sheets("¬d¸ßªí1").Range("a1:B5")), Range(Sheets("¬d¸ßªí2").Range("a1:B5"))).Copy
Range("D1").Select
ActiveSheet.Paste

­n±N¨â¬d¸ßªíªºa1¨ìb5¦X¨Ö°Å¶K¨ì¨Ï¥Î¤¤¤u§@ªíªºd1Àx¦s®æ
¸Ó«ç»ò§ï¡H

¦^´_ 1# ¹q·xÄl
¸ó¤½§@ªí¦P®É«þ¨©¦A¶K¤W¥i¯à¤£¦æ,¥i¥H¦Ò¼{¤À¨â¬q¼g :

Sheets("¬d¸ßªí1").Range("a1:B5").Copy Range("D1")
Sheets("¬d¸ßªí2").Range("a1:B5").Copy Range("F1")

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD