Advertisement
YasserKhalil2019

T4061_Hide Rows Using AutoFilter By Two Criteria

Oct 8th, 2019
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. https://excel-egy.com/forum/t4061
  2. ---------------------------------
  3.  
  4. Sub Hide_Rows_Using_AutoFilter_By_Two_Criteria()
  5. Application.ScreenUpdating = False
  6. With ActiveSheet
  7. .AutoFilterMode = False
  8. With .Range("A2:O" & .Cells(Rows.Count, 1).End(xlUp).Row)
  9. .AutoFilter 15, "<>0", xlAnd, "<>"
  10. End With
  11. End With
  12. Application.ScreenUpdating = True
  13. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement