PDA

View Full Version : Shorten



zhead
08-22-2018, 10:22 AM
is it possible to shorten these type of queries and not change the outcome?


With Range("AE8")
.Value2 = Application.CountIfs(Range("U:U"), "SC", Range("I:I"), "OPEN", Range("C:C"), "*MOC*", Range("P:P"), ">7", Range("F:F"), "*SYS GEN*", _
Range("Q:Q"), "DY", Range("J:J"), "<>X") + Application.CountIfs(Range("U:U"), "SC", Range("I:I"), "OPEN", Range("R:R"), "*MOC*", Range("P:P"), _
">7", Range("F:F"), "*SYS GEN*", Range("C:C"), "<>*MOC*", Range("Q:Q"), "DY", Range("J:J"), "<>X")