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

¤£¦P¤u§@ªí §ì©T©wÄæ¦ì¸ê®Æ

¤£¦P¤u§@ªí §ì©T©wÄæ¦ì¸ê®Æ

½Ð±Ð«e½ú - §Ú¦³­ÓÀÉ®×....¦³«Ü¦hªº¤u§@ªí(¦WºÙ¤£¤@)
¨ä¤¤ ¦³2­Ó Äæ¦ì¸ê®Æ ( B2 & E6 )
§Ú­n§ì¨ì¤@±i·sªº·JÁ`¤u§@ªí §e²{¦p¹Ï¥Ü

¥t¥~¦pªG - E7 ¤]­n¤@°_§ì¹L¨Ó
©ñ¦b·JÁ`ªí D Äæ

½Ð±Ð«e½ú VBA ­n¦p¦ó³]¸m ? ·P®¦¤£ºÉ ! ÁÂÁÂ

2.gif (34.81 KB)

2.gif

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-11-19 12:23 ½s¿è

¦^´_ 1# hanse
  1. Option Explicit
  2. Sub Ex()
  3.     Dim Sh, Ar, i As Integer, X As Long
  4.      '***   ¤@­ÓÀÉ®×   ****....¦³«Ü¦hªº¤u§@ªí(¦WºÙ¤£¤@)
  5.      Sh = Array("¦WºÙA", "¦WºÙB", "¦WºÙC", "¦WºÙD", "¦WºÙE")
  6.      For i = 0 To UBound(Sh)
  7.         With Sheets(Sh(i))
  8.             Ar = Array(.Range("B2"), .Range("E6"), .Range("E7"))
  9.         End With
  10.         With Sheets("·JÁ`ªí")
  11.             X = 2 + Application.CountA(.Range("D2:d" & .Rows.Count)) '¤u§@ªí¨ç¼Æ CountA
  12.             .Range("D" & X).Resize(, 3) = Ar
  13.         End With
  14.      Next
  15. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¤u§@ªíªº¦WºÙ¥i¥H¤£­n«ü©w¶Ü ?
´N¬O³o­ÓÀɮפ¤    ©Ò¦³ªº¤u§@ªí-¬Û¹ïÀ³ªºÄæ¦ì ³£§ì¨ì"·JÁ`ªí¤¤ ?

TOP

¦^´_ 3# hanse
  1. Option Explicit
  2. Sub Ex()
  3.     Dim Sh As Worksheet, X As Long
  4.      For Each Sh In ThisWorkbook.Sheets
  5.         If Sh.Name <> "·JÁ`ªí" Then
  6.             With Sheets("·JÁ`ªí")
  7.                 X = 2 + Application.CountA(.Range("D2:d" & .Rows.Count)) '¤u§@ªí¨ç¼Æ CountA
  8.                 .Range("D" & X).Resize(, 3) = Array(Sh.Range("B2"), Sh.Range("E6"), Sh.Range("E7"))
  9.             End With
  10.         End If
  11.      Next
  12. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¯« !!  ·P®¦ !

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD