Public Sub Sample_1()
Dim rC As Range
Dim psRow As Long
psRow = 1
For Each rC In Sheet1.AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible)
If rC.Row > 1 Then
Sheet2.Range("A" & psRow & ":C" & psRow).Value = Sheet1.Range("A" & rC.Row & ":C" & rC.Row).Value
psRow = psRow + 1
End If
Next rC
End Sub
|