Mình sửa như bạn hướng dẫn rồi mà sao không được,bạn xem Code:
Private Sub CommandButton1_Click()
Dim tng, dng
Dim Rng As Range
Sheet3.[A33:CT65536].ClearContents
Sheet4.[A33:CT65536].ClearContents
With HS
On Error GoTo thoat
.Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=2, _
Criteria1:=">=" & IIf(Me.Cb_tu = "", Cb_tu.List(0), Cb_tu), Operator:=xlAnd, _
Criteria2:="<=" & IIf(Cb_den = "", Cb_den.List(Cb_den.ListCount - 1), Cb_den)
If Cb_F <> "" Then .Range("A3:BB" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=6, Criteria1:=Cb_F
If Cb_G <> "" Then .Range("A3:BB" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=7, Criteria1:=Cb_G
If Cb_H <> "" Then .Range("A3:BB" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=8, Criteria1:=Cb_H
Set Rng = .AutoFilter.Range.Offset(1, 0).Resize(.AutoFilter.Range.Rows. _
Count - 1).SpecialCells(xlCellTypeVisible)
Rng.Copy Destination:=Sheet3.[B33]
.Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter
.Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=2, _
Criteria1:="=" & IIf(Me.ComboBox1 = "", Me.ComboBox1.List(0), Me.ComboBox1)
If Cb_F <> "" Then .Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=6, Criteria1:=Cb_F
If Cb_G <> "" Then .Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=7, Criteria1:=Cb_G
If Cb_H <> "" Then .Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter Field:=8, Criteria1:=Cb_H
Set Rng = .AutoFilter.Range.Offset(1, 0).Resize(.AutoFilter.Range.Rows. _
Count - 1).SpecialCells(xlCellTypeVisible)
Rng.Copy Destination:=Sheet4.[B33]
thoat:
.Range("A3:CT" & HS.[a65536].End(xlUp).Row).AutoFilter
End With
If WorksheetFunction.CountA(Sheet3.[D33
34]) > 0 Then
With Sheet3.[A33].Resize(Sheet3.[c65536].End(xlUp).Row - 32)
.Formula = "=row()-32"
.Value = .Value
End With
End If
If WorksheetFunction.CountA(Sheet4.[D33
34]) > 0 Then
With Sheet4.[A33].Resize(Sheet4.[c65536].End(xlUp).Row - 32)
.Formula = "=row()-32"
.Value = .Value
End With
End If
Sheet9.Activate
End Sub
Ở Sheet 3 Và 4 Nó bị đơ,không thể cuộn xuống được.bạn xem lại cho mình với,Cảm ơn bạn