|
修改后,
Private Sub CommandButton1_Click()
Dim cell As Range, rng As Range
Dim rn As Range, rnn As Range
With Sheets("总花名册")
For Each cell In .Range("g5:g" & .Cells(Rows.Count, 7).End(xlUp).Row)
If cell <= 15 And cell >= 13 Then
If rng Is Nothing Then
Set rng = cell.Offset(, -6).Resize(1, 7)
Set rn = cell.Offset(, 11)
Set rnn = cell.Offset(, 33)
Else
Set rng = Union(rng, cell.Offset(, -6).Resize(1, 7))
Set rn = Union(rn, cell.Offset(, 11))
Set rnn = Union(rnn, cell.Offset(, 33))
End If
End If
Next
End With
rng.Copy Range("a8")
rn.Copy Range("N8")
rnn.Copy Range("X8")
End Sub |
|