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

hanse

½Ð±Ð«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®¦¤£ºÉ ! ÁÂÁÂ

¤U¸ü (34.81 KB)

2013-11-19 10:15

¤U¸ü (29.34 KB)

2013-11-19 10:16

GBKEE

¦^´_ 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

hanse

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

GBKEE

¦^´_ 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

hanse

¯« !!  ·P®¦ !