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

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