Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. Sub FixSortings
  2. tbl.Sort.SortFields.Clear
  3. tbl.Sort.SortFields.Add Key:=Range("Tabell2[[#All],[Ref dato]]"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
  4.  
  5. With tbl.Sort
  6. .Header = xlYes
  7. .MatchCase = False
  8. .Orientation = xlTopToBottom
  9. .SortMethod = xlPinYin
  10. .Apply
  11. End With
  12.  
  13. tbl.ShowAutoFilter = False
  14.  
  15. 'tbl.Range.AutoFilter Field:=9, Criteria1:=">=" & CStr(Format(DateAdd("m", -6, Now()), "dd.mm.yy")), Operator:=xlAnd, Criteria2:="<=" & CStr(Format(Now(), "dd.mm.yy"))
  16. 'tbl.Range.AutoFilter Field:=9, Criteria1:=">=" & CStr(Format(DateAdd("m", -6, Now()), "mm.dd.yy")), Operator:=xlAnd, Criteria2:="<=" & CStr(Format(Now(), "mm.dd.yy"))
  17. 'tbl.Range.AutoFilter Field:=9, Criteria1:=">=22.08.2016", Operator:=xlAnd, Criteria2:="<=22.02.2017"
  18. ActiveSheet.ListObjects("Tabell2").Range.AutoFilter Field:=9, Criteria1:=">=22.08.2016", Operator:=xlAnd, Criteria2:="<=22.02.2017"
  19. End Sub
  20.  
  21. tbl.Range.AutoFilter Field:=9, _
  22. Criteria1:=">=" & CStr(Format(DateAdd("m", -6, Now()), "yyyy-mm-dd")), _
  23. Operator:=xlAnd, _
  24. Criteria2:="<=" & CStr(Format(Now(), "yyyy-mm-dd"))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement