Thread: How to Add a line of code to count highlighted cells
View Single Post
 
Old 06-23-2016, 04:43 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You need:

Code:
Selection.AutoFilter Field:=12, Criteria1:=RGB(255, 255, 0), Operator:=xlFilterCellColor
Reply With Quote