Can anyone know what is the problem in my code?
Here's the result when I run my program;
Capture.PNG
12.PNG
![]()
Private Sub CommandButton1_Click() Dim ws1 As Worksheet Application.Workbooks("WU_P1 FOR MACRO.xlsb").Activate Set ws1 = Sheets("Sheet1") With ws1 .AutoFilterMode = False .Range("I1:I" & .Range("I" & Rows.Count).End(xlUp).Row).AutoFilter Field:=1, Criteria1:=Array("#N/A", "0000000", "6XXXXXX", "DUMMY", "DUMMY BUILD", "N/A", "NA", "STAMSDUMMY", "TBA", "TBD", ""), Operator:=xlFilterValues .AutoFilter.Range.Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Cut .AutoFilterMode = False End With Application.Sheets("Sheet3").Select Range("A2").Select Selection.Insert Shift:=xlDown Application.ScreenUpdating = True End Sub











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks