Thread: How to Add a line of code to count highlighted cells
View Single Post
 
Old 06-23-2016, 05:06 AM
zhead zhead is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default
Debaser
Thanks! that worked great.
Is it possible to add , Range("L:L"), "Yellow" to this?

Code:
With Range("AL2")
.Value2 = Application.CountIfs(Range("U:U"), "OC", Range("H:H"), "OPEN", Range("W:W"), ">0", Range("X:X"), ">15%", Range("F:F"), "*SYS GEN*", Range("C:C"), "<>*MOC*", Range("P:P"), "<>*MOC*")
.NumberFormat = "#,##0"
End With
Reply With Quote