ndjustin20
Board Regular
- Joined
- May 25, 2011
- Messages
- 69
ok...this should be simple right?!!??!! I am using the following code and it keeps throwing an 1004 obj defined error. I have used this before but now it doesn't want to work. Any ideas:
Code:
Sub FindGoodGreen()
ActiveSheet.Range("$A$1:$T$136").AutoFilter Field:=3, Criteria1:=RGB(55, 245 _
, 64), Operator:=xlFilterCellColor
ActiveSheet.Range("2:7").Rows.Hidden = False
End Sub