How to Add a line of code to count highlighted cells

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to Add a line of code to count highlighted cells

FAQ

Thread Tools

Display Modes

06-23-2016, 05:06 AM

zhead

Windows 7 64bit How to Add a line of code to count highlighted cells

Office 2010 64bit

Advanced Beginner

Join Date: Mar 2015

Location: Texas

Posts: 32

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula cells are not highlighted when double clicking result	hockeytown	Excel	2	12-03-2015 09:57 AM
Multiple cells highlighted on mouse click	mrsm	Excel	0	03-02-2015 12:43 PM
White font not showing text when highlighted across multiple cells	hockeytown	Excel	3	12-16-2014 08:58 AM
predefine thick border colored lines for highlighted cells	dylansmith	Excel	0	09-05-2014 07:49 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.